How to get the name of the database in Redshift

Run the below query to return the name of the database you are currently connected to.

select current_database();
See also  How to determine the number of objects in an s3 bucket