psql see databases code example
Example 1: postgresql show current database
SELECT current_database();
Example 2: postgresql list db
postgres=# \l
Example 3: postgres how to list all databases
List all databases:
\l
SELECT current_database();
postgres=# \l
List all databases:
\l