What does the \\d command do?

The \d command is used in PostgreSQL's interactive terminal (psql) to display the structure of a database table. When you run \d table_name, it provides detailed information about the specified table, including:

• Column names
• Data types of each column
• Constraints (such as primary keys, foreign keys, unique constraints)
• Indexes associated with the table

Example Usage

To see the structure of a table named employees, you would use:

\d employees

This command will output the schema of the employees table, showing all relevant details about its columns and constraints.