By Alvin Alexander. Last updated: June 30, 2021
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.