How to List Tables in PostgreSQL

Last updated July 24, 2026 · By the SaturnSQL team

In psql, \dt lists tables in the search path. From SQL, query pg_tables or information_schema.tables; pg_total_relation_size adds on-disk sizes.

\dt
\dt archive.*

SELECT tablename,
       pg_size_pretty(pg_total_relation_size(quote_ident(tablename))) AS size
FROM pg_tables
WHERE schemaname = 'public'
ORDER BY pg_total_relation_size(quote_ident(tablename)) DESC;