Logical Structure of Postgres

Postgres Cluster -> Databases -> Schemas -> Tables

This is the logical structure we have in Postgres.

Cluster manages multiple databases, which contain schemas.

Within schemas, we have tables, fundamental units for storing data.

To view your databases, you can use pg_database, and for tables, views, indexes and other relations, use pg_class.