List all tables in the current database
Read-only
What do risk levels mean?
- Read-only
- Inspects state without changing anything.
- Low risk
- Reversible with a routine follow-up command.
- Medium risk
- Changes state; undo path documented.
- Destructive
- Deletes or overwrites; confirmation required.
Shows every table in the connected database, including schema-qualified names, so you can survey the data model before writing queries or performing schema changes.
postgresqltablesschemainspect
Commands
List every table with schema, name, type, and owner
psql -c "\dt"Verification
psql -c "\dt"A table of relations is printed; an empty result means no user tables exist.
Undo
Not undoable
This recipe only reads catalog metadata and changes nothing.
Pitfalls
- System catalog tables are excluded by default; use \dt *.* to include them.
- Table names are schema-qualified; the public schema is the default for most applications.