How to view table structure in a PG database?

4 months ago

1 minute

In PostgreSQL database, you can use the following SQL command to view the structure of a table:

\d table_name;

Alternatively, you can use the following SQL command to view the detailed structure of the table:

\d+ table_name;

The table_name is the name of the table whose structure is being viewed. These commands will show information such as column names, data types, and constraints of the table.