Mega Code Archive

 

Categories / PostgreSQL / Postgre SQL

 

Displays all tables in the connected database, with comments

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