List all databases and Show Database

List all databases

dbadmin=> \l

 List of databases

 name | user_name

-------+-----------

 Otter | dbadmin

(1 row)

Other commands (\d? [Pattern]) are as follows: (Case insensitive)

Command	List All	Example
\l	Databases
\df	functions	\df *date*
\dn	Schemas
\dt	Tables	\dt *     \dt public.*
\dtv	Tables and views	\dtv  Sub*
\dv	Views
\dp	Projections and privileges
\du	Users
\ds	Sequences
\dS	System Tables
\z	Table access privileges

List database configuration parameters

·       You must have super user privileges to view some values. If you are not the super user, and you use the keyword 'ALL', parameter values are masked with ****. If the parameter is specifically listed, an error message appears.

·       Non-superusers cannot view database or node-level security parameters.

SHOW DATABASE VMart ALL;

         Name            |        setting

-------------------------+------------------------

 AnalyzeRowCountInterval | 3600

 DefaultSessionLocale    | en_US@collation=binary

 JavaBinaryForUDx        | /usr/bin/java