ANDa.attnum>0

AND NOTa.attisdropped

ANDa.attnotnull

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

AND pg_has_role(r.relowner,'USAGE');

GRANTSELECTON check_constraints TO PUBLIC;

ANDa.attrelid=c.oid

ANDa.atttypid=t.oid

ANDt.typtype='d'

ANDc.relkindIN ('r','v','f')

ANDc.relkindIN ('r','v','f','P')

ANDa.attnum>0

AND NOTa.attisdropped

AND pg_has_role(t.typowner,'USAGE');

pr_c.relowner

FROM (SELECToid, relname, relnamespace, relowner, (aclexplode(coalesce(relacl, acldefault('r', relowner)))).*

FROM pg_class

WHERE relkindIN ('r','v','f')

WHERE relkindIN ('r','v','f','P')

) pr_c (oid, relname, relnamespace, relowner, grantor, grantee, prtype, grantable),

pg_attribute a

WHEREa.attrelid=pr_c.oid

) pr_a (attrelid, attname, grantor, grantee, prtype, grantable),

pg_class c

WHEREpr_a.attrelid=c.oid

AND relkindIN ('r','v','f')

AND relkindIN ('r','v','f','P')

) x,

pg_namespace nc,

pg_authid u_grantor,

WHEREa.attrelid=c.oid

ANDa.atttypid=t.oid

ANDnc.oid=c.relnamespace

ANDa.attnum>0AND NOTa.attisdroppedANDc.relkindin ('r','v','f')

ANDa.attnum>0AND NOTa.attisdroppedANDc.relkindin ('r','v','f','P')

AND pg_has_role(coalesce(bt.typowner,t.typowner),'USAGE');

GRANTSELECTON column_udt_usage TO PUBLIC;

CAST('NEVER'AS character_data)AS is_generated,

CAST(nullAS character_data)AS generation_expression,

CAST(CASE WHENc.relkind='r'OR

CAST(CASE WHENc.relkindIN ('r','P')OR

(c.relkindIN ('v','f')AND

pg_column_is_updatable(c.oid,a.attnum, false))

THEN'YES' ELSE'NO' ENDAS yes_or_no)AS is_updatable

WHERE (NOT pg_is_other_temp_schema(nc.oid))

ANDa.attnum>0AND NOTa.attisdroppedANDc.relkindin ('r','v','f')

ANDa.attnum>0AND NOTa.attisdroppedANDc.relkindin ('r','v','f','P')

AND (pg_has_role(c.relowner,'USAGE')

OR has_column_privilege(c.oid,a.attnum,

ANDd.objid=c.oid

ANDc.connamespace=nc.oid

ANDc.contype='c'

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

AND NOTa.attisdropped

ELSEr.oid=c.conrelidANDa.attnum= ANY (c.conkey) END)

AND NOTa.attisdropped

ANDc.contypeIN ('p','u','f')

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

)AS x (tblschema, tblname, tblowner, colname, cstrschema, cstrname)

WHEREc.connamespace=nc.oidANDr.relnamespace=nr.oid

AND ( (c.contype='f'ANDc.confrelid=r.oid)

OR (c.contypeIN ('p','u')ANDc.conrelid=r.oid) )

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

AND pg_has_role(r.relowner,'USAGE');

GRANTSELECTON constraint_table_usage TO PUBLIC;

ANDr.oid=c.conrelid

ANDnc.oid=c.connamespace

ANDc.contypeIN ('p','u','f')

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

AND (NOT pg_is_other_temp_schema(nr.oid)) )AS ss

WHEREss.roid=a.attrelid

ANDa.attnum= (ss.x).x

WHEREnc.oid=c.connamespaceANDnr.oid=r.relnamespace

ANDc.conrelid=r.oid

ANDc.contype NOTIN ('t','x')-- ignore nonstandard constraints

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

AND (NOT pg_is_other_temp_schema(nr.oid))

AND (pg_has_role(r.relowner,'USAGE')

ANDa.attnotnull

ANDa.attnum>0

AND NOTa.attisdropped

ANDr.relkind='r'

ANDr.relkindIN ('r','P')

AND (NOT pg_is_other_temp_schema(nr.oid))

AND (pg_has_role(r.relowner,'USAGE')

)AS grantee (oid, rolname)

WHEREc.relnamespace=nc.oid

ANDc.relkindIN ('r','v')

ANDc.relkindIN ('r','v','P')

ANDc.grantee=grantee.oid

ANDc.grantor=u_grantor.oid

ANDc.prtypeIN ('INSERT','SELECT','UPDATE','DELETE','TRUNCATE','REFERENCES','TRIGGER')

CAST(

CASE WHENnc.oid= pg_my_temp_schema() THEN'LOCAL TEMPORARY'

WHENc.relkind='r' THEN'BASE TABLE'

WHENc.relkindIN ('r','P') THEN'BASE TABLE'

WHENc.relkind='v' THEN'VIEW'

WHENc.relkind='f' THEN'FOREIGN TABLE'

ELSEnull END

CAST(nt.nspnameAS sql_identifier)AS user_defined_type_schema,

CAST(t.typnameAS sql_identifier)AS user_defined_type_name,

CAST(CASE WHENc.relkind='r'OR

CAST(CASE WHENc.relkindIN ('r','P')OR

(c.relkindIN ('v','f')AND

pg_relation_is_updatable(c.oid, false) &8=8)

FROM pg_namespace ncJOIN pg_class cON (nc.oid=c.relnamespace)

LEFT JOIN (pg_type tJOIN pg_namespace ntON (t.typnamespace=nt.oid))ON (c.reloftype=t.oid)

WHEREc.relkindIN ('r','v','f')

WHEREc.relkindIN ('r','v','f','P')

AND (NOT pg_is_other_temp_schema(nc.oid))

AND (pg_has_role(c.relowner,'USAGE')

OR has_table_privilege(c.oid,'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER')

ANDdt.refclassid='pg_catalog.pg_class'::regclass

ANDdt.refobjid=t.oid

ANDt.relnamespace=nt.oid

ANDt.relkindIN ('r','v','f')

ANDt.relkindIN ('r','v','f','P')

ANDt.oid=a.attrelid

ANDdt.refobjsubid=a.attnum

AND pg_has_role(t.relowner,'USAGE');

ANDdt.refclassid='pg_catalog.pg_class'::regclass

ANDdt.refobjid=t.oid

ANDt.relnamespace=nt.oid

ANDt.relkindIN ('r','v','f')

ANDt.relkindIN ('r','v','f','P')

AND pg_has_role(t.relowner,'USAGE');

GRANTSELECTON view_table_usage TO PUBLIC;

a.attnum,a.atttypid,a.attcollation

FROM pg_class c, pg_attribute a

WHEREc.oid=a.attrelid

ANDc.relkindIN ('r','v','f','c')

ANDc.relkindIN ('r','v','f','c','P')

AND attnum>0AND NOT attisdropped

C.relrowsecurityAS rowsecurity

FROM pg_class CLEFT JOIN pg_namespace NON (N.oid=C.relnamespace)

LEFT JOIN pg_tablespace TON (T.oid=C.reltablespace)

WHEREC.relkind='r';

WHEREC.relkindIN ('r','P');

l.objoid,l.classoid,l.objsubid,

CASE WHENrel.relkind='r' THEN'table'::text

CASE WHENrel.relkindIN ('r','P') THEN'table'::text

WHENrel.relkind='v' THEN'view'::text

WHENrel.relkind='m' THEN'materialized view'::text

WHENrel.relkind='S' THEN'sequence'::text

l.classoid,

l.objsubid,

CASE

WHEN (rel.relkind = 'r'::"char") THEN 'table'::text

WHEN (rel.relkind =ANY (ARRAY['r'::"char", 'P'::"char"])) THEN 'table'::text

WHEN (rel.relkind = 'v'::"char") THEN 'view'::text

WHEN (rel.relkind = 'm'::"char") THEN 'materialized view'::text

WHEN (rel.relkind = 'S'::"char") THEN 'sequence'::text

FROM ((pg_class c

LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))

LEFT JOIN pg_tablespace t ON ((t.oid = c.reltablespace)))

WHERE (c.relkind = 'r'::"char");

WHERE (c.relkind =ANY (ARRAY['r'::"char", 'P'::"char"]));

pg_timezone_abbrevs| SELECT pg_timezone_abbrevs.abbrev,

pg_timezone_abbrevs.utc_offset,

pg_timezone_abbrevs.is_dst