Postgresql - How to list all tables in a Postgresql database

"Postgres show tables" FAQ: How do I list all the tables in my current Postgresql database?

Once you're logged into a Postgresql database using the psql client, issue this command at the psql prompt to show all the tables in your Postgres database:

\dt

This will list all of the tables in the current database.

 

Post new comment

The content of this field is kept private and will not be shown publicly.