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

amazon-web-services amazon-redshift
Arafat Nalkhande picture Arafat Nalkhande · Mar 21, 2017 · Viewed 11.1k times · Source

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

avertocle picture avertocle · Mar 21, 2017

Please try this.

    SELECT * FROM pg_database;

Related questions

Show tables, describe tables equivalent in redshift

I'm new to aws, can anyone tell me what are redshifts' equivalents to mysql commands? show tables -- redshift command describe table_name -- redshift command

Read More
Alter column data type in Amazon Redshift

How to alter column data type in Amazon Redshift database? I am not able to alter the column data type in Redshift; is there any way to modify the data type in Amazon Redshift?

Read More
how to find size of database, schema, table in redshift

Team, my redshift version is: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.735 how to find out database size, tablespace, schema size & table size ? but below are not working in redshift ( for above …

Read More