Postgres show table columns

Summary: in this tutorial, you will learn how to show tables in PostgreSQL using tool and schema.

MySQL offers a popular statement that displays all tables in a specific database.

Unfortunately, PostgreSQL does not support the statement directly but provides you with alternatives.

First, open the Command Prompt on Windows or Terminal on Unix-like systems and connect to the PostgreSQL using psql client tool:

Second, change the current database to the one that you want to show tables:

Note that you can connect to a specific database when you log in to the PostgreSQL database server:

In this command, the flag means database.

In this command, you connect to the database using the user.

Third, use the command from the PostgreSQL command prompt to show tables in the database:

Output:

To get more information on tables, you can use the command.

It will add the and columns:

Output:

To show the details of a specific table, you can specify the name of the table after the \d command:

Or

For example, the following shows the structure of the actor table:

Ou

postgresql show tablespaces

postgresql show tables from database