show database in postgres code example

Example 1: get all tables postgres

SELECT * FROM pg_catalog.pg_tables;

Example 2: postgresql show current database

SELECT current_database();

Example 3: postgresql list db

postgres=# \l

Example 4: postgres show databases

# List databases:
\l

Example 5: postgres list databases

postgres=# \l