psql see current db code example

Example: postgresql show current database

SELECT current_database();