List all tables in all schemas except pg_catalog and information_schema

PHOTO EMBED

Sun Sep 18 2022 16:59:33 GMT+0000 (UTC)

Saved by @aguest #sql

SELECT
  table_schema,
  table_name
FROM
  information_schema.tables
WHERE
  table_schema NOT IN ('pg_catalog', 'information_schema')
  AND table_type = 'BASE TABLE';
content_copyCOPY