Displays all databases available, with comments : Postgre SQL Command « Postgre SQL « PostgreSQL






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

Displays all databases available, with comments

postgres=#
postgres=# -- Displays all databases available, with comments
postgres=# \l+
                      List of databases
   Name    |  Owner   | Encoding  |        Description
-----------+----------+-----------+---------------------------
 postgres  | postgres | SQL_ASCII |
 template0 | postgres | SQL_ASCII |
 template1 | postgres | SQL_ASCII | Default template database
(3 rows)

postgres=#
postgres=#








Related examples in the same category

1.Command can be used to view all sequences in the currently connected database
2.Listing psql slash commands
3.The variable list
4.Displays all database objects, with comments
5.Displays all database objects in the connected database, with comments
6.Displays all tables 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