The PostgreSQL Logical Databases table provides metadata about logical databases discovered in PostgreSQL instances. Each row represents a logical database and includes information such as database name, encoding, owner, and a join key to navigate up the hierarchy to the database instance. This table enables you to inventory logical databases, analyze database ownership, and walk the hierarchy (logical database to database instance). The whole hierarchy is postgres_tables → postgres_schemas → postgres_logical_databases → database_instances (4 tables).

dd.postgres_logical_databases

Fields