PostgreSQL Catalogs: Tablelist
This is an example of a simple tabular report.
tablelist
set search_path to public, ere, rugby;
SELECT n.nspname as "schema", c.relname as "name",
CASE c.relkind
WHEN 'r' THEN 'table'
WHEN 'v' THEN 'view'
WHEN 'i' THEN 'index'
WHEN 'S' THEN 'sequence' WHEN 's'
THEN 'special' END as "type",
u.usename as "owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','v','S','')
AND n.nspname NOT IN ('pg_toast')
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
schema, name, type, owner
detail
| Schema | Name | Type | Owner |
|---|
| _schema_ | _name_ | _type_ | _owner_ |