/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 …]
|