<entry><type>char</type></entry>

<entry></entry>

<entry>

<literal>r</> = ordinary table, <literal>P</> = partitioned table,

<literal>i</> = index

<literal>S</> = sequence, <literal>v</> = view,

<literal>r</> = ordinary table,

<literal>i</> = index,

<literal>S</> = sequence,

<literal>t</> = TOAST table,

<literal>v</> = view,

<literal>m</> = materialized view,

<literal>c</> = composite type, <literal>t</> = TOAST table,

<literal>f</> = foreign table

<literal>c</> = composite type,

<literal>f</> = foreign table,

<literal>p</> = partitioned table

</entry>

</row>

ONa.attcollation=co.oidAND (nco.nspname,co.collname)<> ('pg_catalog','default')

WHEREa.attnum>0AND NOTa.attisdropped

ANDc.relkindin ('c')

ANDc.relkindIN ('c')

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

OR has_type_privilege(c.reltype,'USAGE'));

ANDa.attnum>0

AND NOTa.attisdropped

ANDa.attnotnull

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

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','P')

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','P')

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','P')

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','P')

ANDa.attnum>0AND NOTa.attisdropped

ANDc.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.relkindIN ('r','P')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','P')

ANDa.attnum>0AND NOTa.attisdropped

ANDc.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.relkindIN ('r','P')

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

AND NOTa.attisdropped

ANDa.attnum= ANY (CASEc.contype WHEN'f' THENc.confkey ELSEc.conkey END)

AND NOTa.attisdropped

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

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

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.relkindIN ('r','P')

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.relkindIN ('r','P')

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.relkindIN ('r','P')

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.relkindIN ('r','P')

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','P')

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.relkindIN ('r','P') 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.relkindIN ('r','P')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','P')

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','P')

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','P')

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','P')

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.relkindIN ('r','P');

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

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

CASE WHENrel.relkindIN ('r','P') 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

#defineRELKIND_SEQUENCE 'S'/* sequence object */

#defineRELKIND_TOASTVALUE 't'/* for out-of-line values */

#defineRELKIND_VIEW 'v'/* view */

#defineRELKIND_MATVIEW 'm'/* materialized view */

#defineRELKIND_COMPOSITE_TYPE 'c'/* composite type */

#defineRELKIND_FOREIGN_TABLE 'f'/* foreign table */

#defineRELKIND_MATVIEW 'm'/* materialized view */

#defineRELKIND_PARTITIONED_TABLE 'P'/* partitioned table */

#defineRELKIND_PARTITIONED_TABLE 'p'/* partitioned table */

#defineRELPERSISTENCE_PERMANENT'p'/* regular table */

#defineRELPERSISTENCE_UNLOGGED'u'/* unlogged permanent table */

#defineREPLICA_IDENTITY_FULL'f'

#defineREPLICA_IDENTITY_INDEX'i'

SELECT relkind FROM pg_class WHERE relname = 'partitioned';

relkind

---------

(1 row)

-- check that range partition key columns are marked NOT NULL

l.classoid,

l.objsubid,

CASE

WHEN (rel.relkind = ANY (ARRAY['r'::"char", 'P'::"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 = ANY (ARRAY['r'::"char", 'P'::"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

\a\t

SELECT relname, relhasindex

FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = relnamespace

WHERE relkind IN ('r', 'P') AND (nspname ~ '^pg_temp_') IS NOT TRUE

WHERE relkind IN ('r', 'p') AND (nspname ~ '^pg_temp_') IS NOT TRUE

ORDER BY relname;

a|f

a_star|f

-- Look for illegal values in pg_class fields

SELECT p1.oid, p1.relname

FROM pg_class as p1

WHERE relkind NOT IN ('r', 'i', 's', 'S', 'c', 't', 'v', 'f') OR

WHERE relkind NOT IN ('r', 'i', 'S', 't', 'v', 'm', 'c', 'f', 'p') OR

relpersistence NOT IN ('p', 'u', 't') OR

relreplident NOT IN ('d', 'n', 'f', 'i');

oid | relname

SELECT relname, relhasindex

FROM pg_class cLEFT JOIN pg_namespace nONn.oid= relnamespace

WHERE relkindIN ('r','P')AND (nspname ~'^pg_temp_') IS NOT TRUE

WHERE relkindIN ('r','p')AND (nspname ~'^pg_temp_') IS NOT TRUE

ORDER BY relname;