Mega Code Archive

 

Categories / PostgreSQL / Postgre SQL

 

Displays all database objects in the connected database, with comments

postgres=# postgres=# postgres=# --Displays all database objects in the connected database, with comments. postgres=# \d+                           List of relations  Schema |          Name          |   Type   |  Owner   | Description --------+------------------------+----------+----------+-------------  public | auto_identified        | table    | postgres |  public | auto_identified_id_seq | sequence | postgres |  public | subjects               | table    | postgres |  public | tasklog                | table    | postgres | (4 rows) postgres=#