Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/List tables views and sequences

List relations across schemas.

Back to sheetBrowse commands
Sign in to save
Section: Connect and Inspect with psql

List tables views and sequences

sql
sql
\dt *.*
Explanation

Use patterns like `\dt public.*` to limit output.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Connect and Inspect with psql
List schemas
Show schemas in the current database.
OpenIn sheetsqlsame section
Connect to a database
Open an interactive psql session to a database.
OpenIn sheetbashsame section
Connect with URI
Connect using a full PostgreSQL connection string.
OpenIn sheetbashsame section
List databases
Show all databases in the cluster.
OpenIn sheetsqlsame section
List roles
Show roles and memberships.
OpenIn sheetsqlsame section
Describe a table
Show columns, indexes, defaults, storage details, and more for a relation.
OpenIn sheetsqlsame section