| /dports/databases/pg_citus/citus-10.2.3/src/test/regress/sql/ |
| H A D | alter_database_owner.sql | 16 JOIN pg_roles u
30 JOIN pg_roles u
38 JOIN pg_roles u
53 JOIN pg_roles u
69 JOIN pg_roles u
81 JOIN pg_roles u
87 JOIN pg_roles u
104 JOIN pg_roles u
124 JOIN pg_roles u
142 JOIN pg_roles u
[all …]
|
| /dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/ |
| H A D | alter_database_owner.out | 29 JOIN pg_roles u
51 JOIN pg_roles u
63 JOIN pg_roles u
85 JOIN pg_roles u
114 JOIN pg_roles u
131 JOIN pg_roles u
142 JOIN pg_roles u
175 JOIN pg_roles u
209 JOIN pg_roles u
236 JOIN pg_roles u
[all …]
|
| /dports/sysutils/ansible/ansible-4.7.0/ansible_collections/community/postgresql/tests/integration/targets/postgresql_lang/tasks/ |
| H A D | postgresql_lang_add_owner_param.yml | 47 JOIN pg_roles r ON l.lanowner = r.oid
74 JOIN pg_roles r ON l.lanowner = r.oid
102 JOIN pg_roles r ON l.lanowner = r.oid
130 JOIN pg_roles r ON l.lanowner = r.oid
156 JOIN pg_roles r ON l.lanowner = r.oid
183 JOIN pg_roles r ON l.lanowner = r.oid
|
| /dports/databases/pgmodeler/pgmodeler-0.9.3-beta/schemas/catalog/ |
| H A D | role.sch | 6 …SELECT oid, rolname AS name, current_database() AS parent, 'database' AS parent_type FROM pg_roles]
46 LEFT JOIN pg_roles AS rl ON rl.oid=am.member
50 LEFT JOIN pg_roles AS rl ON rl.oid=am.member
57 FROM pg_roles AS rl1 ]
|
| /dports/sysutils/ansible/ansible-4.7.0/ansible_collections/community/postgresql/tests/integration/targets/postgresql_user/tasks/ |
| H A D | test_no_password_change.yml | 23 …ssrls_supported | ternary(\", 'bypassrls:'||rolbypassrls\", '') }} from pg_roles where rolname='{{…
37 …shell: "echo \"select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';\" |…
59 …eate:'||rolcreatedb, 'inherit:'||rolinherit, 'login:'||rolcanlogin from pg_roles where rolname='{{…
73 …shell: "echo \"select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';\" |…
111 …eate:'||rolcreatedb, 'inherit:'||rolinherit, 'login:'||rolcanlogin from pg_roles where rolname='{{…
125 …shell: echo "select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';" | ps…
|
| /dports/sysutils/ansible2/ansible-2.9.27/test/integration/targets/postgresql/tasks/ |
| H A D | test_no_password_change.yml | 23 …ssrls_supported | ternary(\", 'bypassrls:'||rolbypassrls\", '') }} from pg_roles where rolname='{{…
37 …shell: "echo \"select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';\" |…
59 …eate:'||rolcreatedb, 'inherit:'||rolinherit, 'login:'||rolcanlogin from pg_roles where rolname='{{…
73 …shell: "echo \"select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';\" |…
111 …eate:'||rolcreatedb, 'inherit:'||rolinherit, 'login:'||rolcanlogin from pg_roles where rolname='{{…
125 …shell: echo "select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';" | ps…
|
| /dports/sysutils/py-ansible-base/ansible-base-2.10.15/test/integration/targets/incidental_postgresql_user/tasks/ |
| H A D | test_no_password_change.yml | 23 …ssrls_supported | ternary(\", 'bypassrls:'||rolbypassrls\", '') }} from pg_roles where rolname='{{…
37 …shell: "echo \"select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';\" |…
59 …eate:'||rolcreatedb, 'inherit:'||rolinherit, 'login:'||rolcanlogin from pg_roles where rolname='{{…
73 …shell: "echo \"select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';\" |…
111 …eate:'||rolcreatedb, 'inherit:'||rolinherit, 'login:'||rolcanlogin from pg_roles where rolname='{{…
125 …shell: echo "select 'bypassrls:'||rolbypassrls from pg_roles where rolname='{{ db_user1 }}';" | ps…
|
| /dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | privileges.sql | 1710 pg_roles
1720 pg_roles
1759 pg_roles
1776 pg_roles
1824 pg_roles
1834 pg_roles
1861 pg_roles
1923 pg_roles
1933 pg_roles
2742 pg_roles
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | privileges.sql | 621 from (select oid from pg_roles where rolname = current_user) as t2;
623 from (select oid from pg_roles where rolname = current_user) as t2;
634 (select oid from pg_roles where rolname = current_user) as t2;
637 (select oid from pg_roles where rolname = current_user) as t2;
655 from (select oid from pg_roles where rolname = current_user) as t2;
664 (select oid from pg_roles where rolname = current_user) as t2;
667 (select oid from pg_roles where rolname = current_user) as t2;
691 (select oid from pg_roles where rolname = current_user) as t2;
694 (select oid from pg_roles where rolname = current_user) as t2;
1076 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 631 from (select oid from pg_roles where rolname = current_user) as t2;
633 from (select oid from pg_roles where rolname = current_user) as t2;
644 (select oid from pg_roles where rolname = current_user) as t2;
647 (select oid from pg_roles where rolname = current_user) as t2;
665 from (select oid from pg_roles where rolname = current_user) as t2;
674 (select oid from pg_roles where rolname = current_user) as t2;
677 (select oid from pg_roles where rolname = current_user) as t2;
701 (select oid from pg_roles where rolname = current_user) as t2;
704 (select oid from pg_roles where rolname = current_user) as t2;
1050 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 640 from (select oid from pg_roles where rolname = current_user) as t2;
642 from (select oid from pg_roles where rolname = current_user) as t2;
653 (select oid from pg_roles where rolname = current_user) as t2;
656 (select oid from pg_roles where rolname = current_user) as t2;
674 from (select oid from pg_roles where rolname = current_user) as t2;
683 (select oid from pg_roles where rolname = current_user) as t2;
686 (select oid from pg_roles where rolname = current_user) as t2;
710 (select oid from pg_roles where rolname = current_user) as t2;
713 (select oid from pg_roles where rolname = current_user) as t2;
1102 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 640 from (select oid from pg_roles where rolname = current_user) as t2;
642 from (select oid from pg_roles where rolname = current_user) as t2;
653 (select oid from pg_roles where rolname = current_user) as t2;
656 (select oid from pg_roles where rolname = current_user) as t2;
674 from (select oid from pg_roles where rolname = current_user) as t2;
683 (select oid from pg_roles where rolname = current_user) as t2;
686 (select oid from pg_roles where rolname = current_user) as t2;
710 (select oid from pg_roles where rolname = current_user) as t2;
713 (select oid from pg_roles where rolname = current_user) as t2;
1102 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 640 from (select oid from pg_roles where rolname = current_user) as t2;
642 from (select oid from pg_roles where rolname = current_user) as t2;
653 (select oid from pg_roles where rolname = current_user) as t2;
656 (select oid from pg_roles where rolname = current_user) as t2;
674 from (select oid from pg_roles where rolname = current_user) as t2;
683 (select oid from pg_roles where rolname = current_user) as t2;
686 (select oid from pg_roles where rolname = current_user) as t2;
710 (select oid from pg_roles where rolname = current_user) as t2;
713 (select oid from pg_roles where rolname = current_user) as t2;
1102 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 640 from (select oid from pg_roles where rolname = current_user) as t2;
642 from (select oid from pg_roles where rolname = current_user) as t2;
653 (select oid from pg_roles where rolname = current_user) as t2;
656 (select oid from pg_roles where rolname = current_user) as t2;
674 from (select oid from pg_roles where rolname = current_user) as t2;
683 (select oid from pg_roles where rolname = current_user) as t2;
686 (select oid from pg_roles where rolname = current_user) as t2;
710 (select oid from pg_roles where rolname = current_user) as t2;
713 (select oid from pg_roles where rolname = current_user) as t2;
1102 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 640 from (select oid from pg_roles where rolname = current_user) as t2;
642 from (select oid from pg_roles where rolname = current_user) as t2;
653 (select oid from pg_roles where rolname = current_user) as t2;
656 (select oid from pg_roles where rolname = current_user) as t2;
674 from (select oid from pg_roles where rolname = current_user) as t2;
683 (select oid from pg_roles where rolname = current_user) as t2;
686 (select oid from pg_roles where rolname = current_user) as t2;
710 (select oid from pg_roles where rolname = current_user) as t2;
713 (select oid from pg_roles where rolname = current_user) as t2;
1102 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 695 from (select oid from pg_roles where rolname = current_user) as t2;
697 from (select oid from pg_roles where rolname = current_user) as t2;
708 (select oid from pg_roles where rolname = current_user) as t2;
711 (select oid from pg_roles where rolname = current_user) as t2;
729 from (select oid from pg_roles where rolname = current_user) as t2;
738 (select oid from pg_roles where rolname = current_user) as t2;
741 (select oid from pg_roles where rolname = current_user) as t2;
765 (select oid from pg_roles where rolname = current_user) as t2;
768 (select oid from pg_roles where rolname = current_user) as t2;
1187 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 695 from (select oid from pg_roles where rolname = current_user) as t2;
697 from (select oid from pg_roles where rolname = current_user) as t2;
708 (select oid from pg_roles where rolname = current_user) as t2;
711 (select oid from pg_roles where rolname = current_user) as t2;
729 from (select oid from pg_roles where rolname = current_user) as t2;
738 (select oid from pg_roles where rolname = current_user) as t2;
741 (select oid from pg_roles where rolname = current_user) as t2;
765 (select oid from pg_roles where rolname = current_user) as t2;
768 (select oid from pg_roles where rolname = current_user) as t2;
1187 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 695 from (select oid from pg_roles where rolname = current_user) as t2;
697 from (select oid from pg_roles where rolname = current_user) as t2;
708 (select oid from pg_roles where rolname = current_user) as t2;
711 (select oid from pg_roles where rolname = current_user) as t2;
729 from (select oid from pg_roles where rolname = current_user) as t2;
738 (select oid from pg_roles where rolname = current_user) as t2;
741 (select oid from pg_roles where rolname = current_user) as t2;
765 (select oid from pg_roles where rolname = current_user) as t2;
768 (select oid from pg_roles where rolname = current_user) as t2;
1187 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 695 from (select oid from pg_roles where rolname = current_user) as t2;
697 from (select oid from pg_roles where rolname = current_user) as t2;
708 (select oid from pg_roles where rolname = current_user) as t2;
711 (select oid from pg_roles where rolname = current_user) as t2;
729 from (select oid from pg_roles where rolname = current_user) as t2;
738 (select oid from pg_roles where rolname = current_user) as t2;
741 (select oid from pg_roles where rolname = current_user) as t2;
765 (select oid from pg_roles where rolname = current_user) as t2;
768 (select oid from pg_roles where rolname = current_user) as t2;
1187 …spname, rolname FROM pg_namespace, pg_roles WHERE pg_namespace.nspname = 'testns' AND pg_namespace…
[all …]
|