Representing Tables (cont)
Details of catalog tables representing database tables
pg_class holds core information about tables
-
relname, relnamespace, reltype, relowner, ...
-
relkind, relnatts, relhaspkey, relacl[], ...
pg_attribute contains information about attributes
-
attrelid, attname, atttypid, attnum, ...
pg_type contains information about types
-
typname, typnamespace, typowner, typlen, ...
-
typtype, typrelid, typinput, typoutput, ...
|