

CREATE TABLE pg_auth_members_1 (
    oid oid,
    roleid oid,
    member oid,
    grantor oid,
    admin_option boolean,
    inherit_option boolean,
    set_option boolean
);

CREATE TABLE pg_roles_1 (
    rolname name,
    rolsuper boolean,
    rolcreaterole boolean,
    rolcanlogin boolean,
    oid oid
);

CREATE TABLE role_graph_detail_1 (
    oid oid,
    rolname name,
    role_type text,
    memberof_users oid[],
    memberof_groups oid[],
    member_users oid[],
    member_groups oid[],
    rolsuper boolean,
    rolcreaterole boolean
);

COPY pg_auth_members_1 (oid, roleid, member, grantor, admin_option, inherit_option, set_option) FROM stdin;
10226	3374	3373	10	f	t	t
10227	3375	3373	10	f	t	t
10228	3377	3373	10	f	t	t
16392	16386	16391	10	t	f	f
16393	16386	16390	16391	f	t	t
16394	16387	16385	10	t	f	f
16395	16387	16391	16385	t	f	f
16396	16387	16391	10	t	f	f
16397	16387	16386	16391	f	t	t
16398	16388	16385	10	t	f	f
16399	16388	16387	16385	f	t	t
16400	16388	16391	10	t	f	f
16401	16388	16387	16391	f	f	t
16402	16389	16385	10	t	f	f
16403	16389	16388	16385	f	t	t
16404	16389	16391	10	t	f	f
16405	16389	16388	16391	f	t	f
\.

COPY pg_roles_1 (rolname, rolsuper, rolcreaterole, rolcanlogin, oid) FROM stdin;
pg_database_owner	f	f	f	6171
pg_read_all_data	f	f	f	6181
pg_write_all_data	f	f	f	6182
pg_monitor	f	f	f	3373
pg_read_all_settings	f	f	f	3374
pg_read_all_stats	f	f	f	3375
pg_stat_scan_tables	f	f	f	3377
pg_read_server_files	f	f	f	4569
pg_write_server_files	f	f	f	4570
pg_execute_server_program	f	f	f	4571
pg_signal_backend	f	f	f	4200
pg_checkpoint	f	f	f	4544
pg_use_reserved_connections	f	f	f	4550
pg_create_subscription	f	f	f	6304
cr_admin	f	t	t	16385
davidj	t	t	t	10
g6a_fixedops_manager_su	f	f	f	16386
g6c_service_manager_su	f	f	f	16387
g6d_service_advisor_su	f	f	f	16388
g6e_service_tech_su	f	f	f	16389
u6_blue_leader_su	f	f	t	16390
u6_green_leader_su	f	f	t	16391
\.

COPY role_graph_detail_1 (oid, rolname, role_type, memberof_users, memberof_groups, member_users, member_groups, rolsuper, rolcreaterole) FROM stdin;
6171	pg_database_owner	Group	\N	\N	\N	\N	f	f
6181	pg_read_all_data	Group	\N	\N	\N	\N	f	f
6182	pg_write_all_data	Group	\N	\N	\N	\N	f	f
3373	pg_monitor	Group	\N	{3374,3375,3377}	\N	\N	f	f
3374	pg_read_all_settings	Group	\N	\N	\N	{3373}	f	f
3375	pg_read_all_stats	Group	\N	\N	\N	{3373}	f	f
3377	pg_stat_scan_tables	Group	\N	\N	\N	{3373}	f	f
4569	pg_read_server_files	Group	\N	\N	\N	\N	f	f
4570	pg_write_server_files	Group	\N	\N	\N	\N	f	f
4571	pg_execute_server_program	Group	\N	\N	\N	\N	f	f
4200	pg_signal_backend	Group	\N	\N	\N	\N	f	f
4544	pg_checkpoint	Group	\N	\N	\N	\N	f	f
4550	pg_use_reserved_connections	Group	\N	\N	\N	\N	f	f
6304	pg_create_subscription	Group	\N	\N	\N	\N	f	f
16385	cr_admin	User	\N	{16387,16388,16389}	\N	\N	f	t
10	davidj	User	\N	\N	\N	\N	t	t
16386	g6a_fixedops_manager_su	Group	\N	{16387,16388,16389}	{16390,16391}	\N	f	f
16387	g6c_service_manager_su	Group	\N	{16388,16389}	{16385,16390,16391}	{16386}	f	f
16388	g6d_service_advisor_su	Group	\N	{16389}	{16385,16390,16391}	{16386,16387}	f	f
16389	g6e_service_tech_su	Group	\N	\N	{16385,16390,16391}	{16386,16387,16388}	f	f
16390	u6_blue_leader_su	User	\N	{16386,16387,16388,16389}	\N	\N	f	f
16391	u6_green_leader_su	User	\N	{16386,16387,16388,16389}	\N	\N	f	f
\.


-- -----------------------------------------------------------------------------
-- 
-- Experiments
-- 
-- -----------------------------------------------------------------------------

SET enable_group_by_reordering=on;

SET enable_group_by_reordering=off;
