SQL

postgresql show current database

SELECT current_database();

show all database inside postgresql

-- Query to get all database in PostgreSQL and their oid (alternative to l) 
SELECT oid, datname FROM pg_database;  

postgres show databases

# List databases:
l

postgres show databases

SELECT datname FROM pg_database;

postgres show databases

# inside psql
l

list all database in postgres

l: for list all databases.

psql show db

SELECT datname FROM pg_database;
Code language: SQL (Structured Query Language) (sql)

show all databases postgres

l
Code language: Shell Session (shell)