🏠 Go back to the homepage How to list tables in the current database using PostgreSQL A quick explanation of how to list tables in the current database inside the `psql` tool in PostgreSQL, or using SQL Published Jan 04 2020 To list the tables in the current database, you can run the \dt command, in psql: If you want to perform an SQL query instead, run this: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name;