DbSchema Database Designer

DbSchema | How to Show Tables in PostgreSQL

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:


Then, select the database:

 \c database_name

To list all the tables execute:



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.*

DbSchema Database Designer

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.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys.

Query Builder alt >

Query Builder

Create SQL Queries using the mouse.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries

Schema Synchronization alt >

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 alt >

Dark Theme

Configurable styles & dark theme.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.