Information_schema.columns postgres

Postgres supports various commands and queries to list all columns of a table in your Postgres database, such as the “\d” or “\d+” commands, “information_schema”, etc. You can also use pgAdmin to access and display all columns of any Postgres table.

This post demonstrates how to list all columns of a specific table using CLI (SQL Shell) and GUI (pgAdmin).

The content of this Postgres post is organized as follows:

• Method 1: Using “\d” or “\d+” Command
• Method 2: Using “information_schema”
• Method 3: Using pg_Admin

Method 1: Using “\d” or “\d+” Command

The “\d” command is used to describe the tables of a database.

Postgres column list of strings

While the “\d+” command describes the Postgres tables in detail. You can use the “\d” or “\d+” command followed by the table name to get the list of all columns of the specific table. For instance, the below command will show the column names of a user-defined table named “staff_info”:

The output shows that the “\d” command retrieves the column names of the “staff_info” table.

Method 2: Using information_schema

Alternatively, you can use the “in