show databases postgres code example

Example 1: mariadb show all databases

SHOW DATABASES;

Example 2: show databases in sql server

SELECT * FROM SYS.DATABASES

Example 3: postgresql show current database

SELECT current_database();

Example 4: postgresql list db

postgres=# \l

Example 5: postgres show databases

# List databases:
\l

Example 6: mysql show tables in database

show tables;