Displays all tables in the connected database, with comments : Postgre SQL Command « Postgre SQL « PostgreSQL






  1. PostgreSQL
  2. Postgre SQL
  3. Postgre SQL Command

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=#








Related examples in the same category

1.Command can be used to view all sequences in the currently connected database
2.Displays all databases available, with comments
3.Listing psql slash commands
4.The variable list
5.Displays all database objects, with comments
6.Displays all database objects in the connected database, with comments
7.Displays all indices in the connected database, with comments
8.Displays all sequences in the connected database, with comments
9.Displays all views in the connected database, with comments
10.Displays all functions in the connected database, with comments
11.Displays all operators in the connected database, with comments
12.Displays all data types in the connected database, with comments
13.To get out of psql
14.timestamp with time zone postmaster start time