How to List Tables in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Query SVV_TABLE_INFO for tables with size and row counts, or information_schema.tables for a plain list. PG_TABLE_DEF only shows tables in your search_path, which is why it often looks empty.
SELECT "schema", "table", tbl_rows, size AS size_mb
FROM svv_table_info
ORDER BY size DESC;information_schema
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
AND table_schema NOT IN ('pg_catalog', 'information_schema')
ORDER BY 1, 2;The PG_TABLE_DEF search_path gotcha
SET search_path TO '$user', public, analytics;
SELECT DISTINCT schemaname, tablename FROM pg_table_def
WHERE schemaname = 'analytics';Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free