List databases and searching a specified database
The examples in this section show how to list the databases in metadata by schema name.
Example– Listing databases
The following example query lists the databases from the
information_schema.schemata table.
SELECT schema_name FROM information_schema.schemata LIMIT 10;
The following table shows sample results.
| 6 | alb-databas1 |
| 7 | alb_original_cust |
| 8 | alblogsdatabase |
| 9 | athena_db_test |
| 10 | athena_ddl_db |
Example– Searching a specified database
In the following example query, rdspostgresql is a sample
database.
SELECT schema_name FROM information_schema.schemata WHERE schema_name = 'rdspostgresql'
The following table shows sample results.
| schema_name | |
|---|---|
| 1 | rdspostgresql |
