CURRENT_DATABASE returns a VARCHAR value containing the name of the database to which you are connected.
Syntax
CURRENT_DATABASE()
Examples
=> SELECT CURRENT_DATABASE;
current_database
------------------
RETAIL_SCHEMA
(1 row)