From the psql command line interface,

First, choose your database

\c database_name

Then, this shows all tables in the current schema:

\dt

Programmatically (or from the psql interface too, of course):

SELECT * FROM pg_catalog.pg_tables;

The system tables live in the pg_catalog database.

Answer from Mihai Limbฤƒศ™an on Stack Overflow
๐ŸŒ
Neon
neon.com โ€บ postgresql โ€บ administration โ€บ show-tables
PostgreSQL Show Tables
Third, use the \dt command from the PostgreSQL command prompt to show tables in the dvdrental database:
๐ŸŒ
GeeksforGeeks
geeksforgeeks.org โ€บ postgresql โ€บ postgresql-show-tables
PostgreSQL - Show Tables - GeeksforGeeks
July 15, 2025 - The psql shell commands such as \dt provide a simple and quick way to list tables, while querying pg_catalog and information_schema offer more advanced options for filtering and joining metadata.
๐ŸŒ
Bytebase
bytebase.com โ€บ references โ€บ postgresql how-to guides โ€บ how to list tables in postgresql
How to list tables in PostgreSQL | PostgreSQL How-to Guide
-- List tables and their indexes SELECT t.schemaname AS table_schema, t.relname AS table_name, i.relname AS index_name, a.attname AS column_name FROM pg_stat_user_tables t JOIN pg_index ix ON t.relid = ix.indrelid JOIN pg_class i ON ix.indexrelid = i.oid JOIN pg_attribute a ON t.relid = a.attrelid AND a.attnum = ANY(ix.indkey) ORDER BY t.relname, i.relname, a.attnum; -- Function to show tables with row counts CREATE OR REPLACE FUNCTION show_tables_with_counts() RETURNS TABLE ( schema_name text, table_name text, row_count bigint ) AS $$ BEGIN FOR schema_name, table_name IN SELECT schemaname, ta
๐ŸŒ
Sentry
sentry.io โ€บ sentry answers โ€บ postgres โ€บ how to show tables in postgresql?
How to show tables in PostgreSQL? | Sentry
The command below assumes your username is postgres and logs into the db database directly: ... You can also use the command \d in psql, instead of \dt, to show all tables, views, sequences, roles, and other database objects.
Find elsewhere
๐ŸŒ
DB Vis
dbvis.com โ€บ thetable โ€บ show-tables-postgresql-guide-two-different-approaches
Show Tables PostgreSQL Guide: Two Different Approaches
July 25, 2024 - Note that PostgreSQL does not support the SHOW TABLES statement directly like MySQL, but it does provide users with other alternatives.
๐ŸŒ
Devart
devart.com โ€บ dbforge โ€บ postgresql โ€บ studio โ€บ postgresql-describe-table.html
PostgreSQL DESCRIBE TABLE
Learn how to describe table structures in PostgreSQL using psql commands, querying information schema, and using dbForge Studio. This guide covers various methods to retrieve detailed table information, including columns, constraints, and more. Perfect for database administrators and developers ...
๐ŸŒ
Quadratic
quadratichq.com โ€บ blog โ€บ postgres-list-tables
How to List Database Tables in PostgreSQL
Especially as your database grows, ... their data. In this post, we'll show you how to list database tables in Postgres and easily visualize them in a spreadsheet with SQL. Below is a simple SQL query listing all the tables in your PostgreSQL database....
๐ŸŒ
PostgreSQL
postgresql.org โ€บ docs โ€บ current โ€บ tutorial-select.html
PostgreSQL: Documentation: 18: 2.5. Querying a Table
May 14, 2026 - The statement is divided into a select list (the part that lists the columns to be returned), a table list (the part that lists the tables from which to retrieve the data), and an optional qualification (the part that specifies any restrictions). For example, to retrieve all the rows of table weather, type:
๐ŸŒ
CommandPrompt Inc.
commandprompt.com โ€บ education โ€บ postgresql-list-all-tables
PostgreSQL List All Tables
November 7, 2022 - PostgreSQL provides a โ€œ\dtโ€ command to list all the available tables of a database. Postgres offers another useful command named โ€œ\dt+โ€ that provides some extra/detailed information about the tables, such as table size, access method, etc.
Call ย  +1-503-667-4564
Address ย  2950 Newmarket ST STE 101 - 231, 98226, Bellingham
๐ŸŒ
Datensen
datensen.com โ€บ home โ€บ blog โ€บ postgresql โ€บ how to list databases and tables in postgresql
How to List Databases and Tables in PostgreSQL
June 18, 2025 - Connect to your PostgreSQL database using the appropriate credentials. Open a new query window or tab. ... SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema NOT IN ('pg_catalog', 'information_schema');
๐ŸŒ
Leapcell
leapcell.io โ€บ blog โ€บ how-to-show-tables-in-postgresql
How to Show Tables in PostgreSQL | Leapcell
July 25, 2025 - GUI tools like pgAdmin simplify table browsing for non-command-line users. In PostgreSQL, unlike MySQL, there isn't a direct SHOW TABLES command. However, PostgreSQL offers several methods to list tables within a database, catering to different needs and preferences.
๐ŸŒ
TablePlus
tableplus.com โ€บ blog โ€บ 2018 โ€บ 04 โ€บ postgresql-how-to-list-all-tables.html
PostgreSQL - How to list all available tables? | TablePlus
April 5, 2018 - To switch and see tables from another schema, navigate to the dropdown schema list at the bottom of the left sidebar and select the schema. Need a good GUI tool for PostgreSQL? Check out TablePlus.
๐ŸŒ
Skyvia
skyvia.com โ€บ home โ€บ gallery โ€บ postgresql show all tables
PostgreSQL: PostgreSQL show all tables - Skyvia
Skyvia is a cloud service for PostgreSQL show all tables integration & backup. Perform PostgreSQL show all tables data import, export, replication, and synchronization easily.
๐ŸŒ
DigitalOcean
digitalocean.com โ€บ community โ€บ questions โ€บ how-to-show-all-tables-in-postgresql
How to show all tables in PostgreSQL? | DigitalOcean
November 13, 2022 - The \dt command is similar to the SHOW TABLES; command in MySQL. To list all tables in the database in all schemas, run the following command: ... The *.* specifies that we want to list all tables in all schemas.
๐ŸŒ
W3Schools
w3schools.com โ€บ postgresql โ€บ postgresql_pgadmin4.php
PostgreSQL - pgAdmin 4
Now you need to enter the password that you created when you installed PostgreSQL, my password is 12345678: Click on the [Database] option on in the menu on the left: You should find a database named postgres, right-click it choose the "Query Tool": In the Query Tool we can start executing SQL statements. Our database is empty, so we cannot query any tables yet, but we can check the version with this SQL statement:
๐ŸŒ
Stackademic
blog.stackademic.com โ€บ how-to-show-tables-in-postgresql-bfbc95e7eda9
How to Show Tables in PostgreSQL? | by Jesse | Stackademic
February 1, 2024 - How to Show Tables in PostgreSQL? My favorite is โ€œSELECT * FROM pg_catalog.pg_tables; โ€ PostgreSQL is a powerful, open-source relational database management system (RDBMS) that is widely used for โ€ฆ