PostgreSQL: List Tables using PSQL

When working in the PostgreSQL interactive terminal (psql), you can list tables quickly using built-in commands.

List All Tables

\dt

This shows all tables in the current database schema. You can also filter by pattern:

\dt public.*

Use:

• \l — show all databases
• \c dbname — connect to database
• \dt — list tables

These commands are handy shortcuts in the PostgreSQL CLI. :contentReference[oaicite:3]{index=3}