How to find the list of databases within an AWS Redshift cluster

Question

I want to list out all the existing databases within a Redshift cluster. How can I do that.

What SQL query can I fire such that it sends me a list of all the databases within the AWS cluster

Answer 1

Please try this.

    SELECT * FROM pg_database;