PostgreSQL - Show Tables [How to]
In this article, you are going to see how simple it is to show all tables from PostgreSQL.
1.Using psql
In this article, we will go over 3 ways to list tables from a PostgreSQL database:
1.List tables from a specific database
To list all available databases from PostgreSQL, execute the next command:
\l
Then, select the database:
\c database_name
To list all the tables execute:
\dt
2.List tables from all schemas
To show tables from all available schemas, execute the next command:
\dt *.*
3.List tables from a specific schema
To show only tables from a specific schema, execute:
\dt schema_name.*
2.Using SQL Query
To show all tables:
SELECT * FROM pg_catalog.pg_tables;
To show only tables from a specific schema, use WHERE function as it follows:
SELECT * FROM pg_catalog.pg_tables WHERE schemaname='schema_name'
Replace ‘schema_name’ with the name of the schema you want.
3.Using DbSchema
DbSchema is a PostgreSQL client and visual designer. DbSchema can be downloaded for free. No registration is required.
Interactive Diagrams
In DbSchema you don’t have to run any query to see the full list of your PostgreSQL database.
The tables are shown in the left menu. From there, you can drag them to the layout to edit or browse.
Relational Data Explorer
Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys.
Query Builder
Create SQL Queries using the mouse.
SQL Query Editor
Edit and execute SQL Queries
Design Schema in Team & Schema Deployment
DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model.
Dark Theme
Configurable styles & dark theme.
DbSchema includes further features, which allows to:
- Design the schema in team and deploy the schema on multiple databases
- Export HTML5 database documentation
- Visually explore the database data
- Build queries using the mouse
- Query editor
- Random data generator
- Data loader