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
In this command, the -d flag means database. In this command, you connect to the dvdrental database using the postgres user. Third, use the \dt command from the PostgreSQL command prompt to show tables in the dvdrental database:
Discussions

show tables in current database using psql
Maybe those tables aren't in the search path? You can use \dn to show all schemas (=namespaces). Then you can e.g. use \dt some_schema.* to show the tables in one specific schema. More on reddit.com
🌐 r/PostgreSQL
7
1
June 15, 2024
How do I list all tables in all schemas owned by the current user in Postgresql? - Database Administrators Stack Exchange
I can list all tables in all schemas using > \dt *.* but that also lists system tables that greatly outnumber my tables that I care about. I'd like all the tables (and possibly views) created b... More on dba.stackexchange.com
🌐 dba.stackexchange.com
December 9, 2012
How to show all tables in PostgreSQL?
It is a relational database management system (RDBMS) based on the SQL language. PostgreSQL is one of the most popular database systems in the world. It is the go-to database for many developers and companies. In this post, I will show you how to list all tables in PostgreSQL using the psql ... More on digitalocean.com
🌐 digitalocean.com
1
November 13, 2022
Any Application I can use to just to view tables and rows with easy UI?
Maybe Jailer's "DataBrowser": https://wisser.github.io/Jailer/data-browsing.html More on reddit.com
🌐 r/PostgreSQL
33
6
January 14, 2024
🌐
Quadratic
quadratichq.com › blog › postgres-list-tables
How to List Database Tables in PostgreSQL
You can query Postgres to list columns and data types (schema) in an individual table by running the following query: SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'your_table_name'; The query returns the schema ...
🌐
GeeksforGeeks
geeksforgeeks.org › postgresql › postgresql-show-tables
PostgreSQL - Show Tables - GeeksforGeeks
July 15, 2025 - To show tables in PostgreSQL, we can use the \dt command in the psql terminal. Alternatively, we can query the pg_catalog or information_schema to list all tables with more detailed information.
🌐
Bytebase
bytebase.com › references › postgresql how-to guides › how to list tables in postgresql
How to list tables in PostgreSQL | PostgreSQL How-to Guide
-- 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, tablename FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') LOOP RETURN QUERY EXECUTE format( 'SELECT %L::text, %L::text, count(*)::bigint FROM %I.%I', schema_name, table_name, schema_name, table_name ); END LOOP; END; $$ LANGUAGE plpgsql; -- Usage: -- SELECT * FROM show_tables_with_counts(); This occurs when a non-privileged user tries to quer
🌐
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
🌐
Atlassian
atlassian.com › data › admin › how to list databases and tables in postgresql using psql
How to List databases and tables in PostgreSQL using psql
Once you’ve connected to a database, you will want to inspect which tables have been created there. This can be done with the \dt meta-command.
🌐
DB Vis
dbvis.com › thetable › show-tables-postgresql-guide-two-different-approaches
Show Tables PostgreSQL Guide: Two Different Approaches
July 25, 2024 - In this use case, we’re going to employ DbVisualizer: Using the pg_catalog schema to list all tables. Using the pg_catalog schema to list all tables. Here, it can be seen that the query has returned the list of tables available at database(postgres)>Schemas>public>Tables, which is the exact path for the tables looking on the left side of the DbVisualizer window pane. The SHOW TABLES PostgreSQL command does not exist, sure.
🌐
Reddit
reddit.com › r/postgresql › show tables in current database using psql
r/PostgreSQL on Reddit: show tables in current database using psql
June 15, 2024 -

Hello, I'm running a psql command inside of my postgres container. When running the \dt to show my database tables it's always giving me "Did not find any relations". Im pretty new in psql commands, am I missing something?

🌐
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.
🌐
Kinsta®
kinsta.com › home › resource center › blog › postgresql › a hands-on guide to listing databases and tables in postgres
A Hands-On Guide to Listing Databases and Tables in Postgres
February 18, 2026 - Adminer then displays a list of the tables, views, routines, sequences, and user types for the database you selected. The information for the test_data database. Alternatively, you can select a database from the DB drop-down on the left-hand side of the page: Dropdown showing available databases. To successfully manage the databases in your Postgres ...
🌐
DbSchema
dbschema.com › blog › postgresql › show tables in postgresql – psql, sql queries, and schema filters | dbschema
Show Tables in PostgreSQL – psql, SQL Queries, and Schema Filters | DbSchema
April 14, 2020 - To show tables in PostgreSQL, use \dt and \dt+ when you are in psql, or query information_schema and pg_catalog when you want SQL-based metadata access. Once you know those basics, filtering by schema, checking size, and jumping into \d table_name ...
🌐
Devart
devart.com › dbforge › postgresql › studio › postgresql-describe-table.html
PostgreSQL DESCRIBE TABLE
For that information, you need to look at the system catalogs or other PostgreSQL-specific views. Let's see how it works! In order to retrieve details about the columns in a specific table, you can query the information_schema.columnsi view. This view contains information about every column in every table in the database.
🌐
CommandPrompt Inc.
commandprompt.com › education › postgresql-how-to-list-all-available-tables
psql list tables - how to use psql \dt, psql \d and pg_tables in postgresql
November 27, 2025 - For this purpose, the below-provided query will be used in Postgres: SELECT tablename, tableowner FROM pg_tables WHERE schemaname = 'public'; The above query retrieves all the tables of the “public” schema.
Address   2950 Newmarket ST STE 101 - 231, 98226, Bellingham
🌐
StrongDM
strongdm.com › blog › security
How to Show/List Tables in PostgreSQL (psql, SQL & pgAdmin)
October 24, 2025 - You need user credentials, usually the username and password, but this will depend on whether the PostgreSQL server needs authentication. You should have enough database access rights, such as CONNECT and USAGE on the relevant schema. To view tables, you may also need SELECT privileges on system catalogs.
🌐
CYBERTEC PostgreSQL
cybertec-postgresql.com › home › show tables in postgresql: what's wrong with it?
SHOW TABLES in PostgreSQL: what's wrong with it? | CYBERTEC PostgreSQL | Services & Support
March 5, 2024 - But as you can see, they will list all the tables in the database, so you probably will need filtering anyway. As I said, there is a SQL-standard way to show tables in PostgreSQL by querying information_schema:
🌐
TablePlus
tableplus.com › blog › 2018 › 04 › postgresql-how-to-list-all-tables.html
PostgreSQL - How to list all available tables? | TablePlus
April 5, 2018 - In TablePlus, you can either use the query editor to run the statements above or see the list of the tables in the current schema on the left sidebar of the workspace. 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?