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