List tables in Redshift

Query below lists all tables in a Redshift database.

Query

select table_schema,
       table_name
from information_schema.tables
where table_schema not in ('information_schema', 'pg_catalog')
      and table_type = 'BASE TABLE'
order by table_schema,
         table_name;

Columns

  • table_schema - schema name
  • table_name - table name

Rows

  • One row represents one table in the database
  • Scope of rows: all tables in the database
  • Ordered by schema and table name

Sample results

You could also get this

Get this interactive HTML data dictionary in minutes with Dataedo.

See live HTML data dictionary sample

Try for free

0
There are no comments. Click here to write the first comment.