For AI agents: A markdown version of this page is available at https://docs.datadoghq.com/ddsql_reference/data_directory/dd/dd.postgres_schemas.dataset.md. A documentation index is available at /llms.txt.

PostgreSQL Schemas

The PostgreSQL Schemas table provides metadata about database schemas discovered in PostgreSQL databases. Each row represents a schema and includes information such as schema name, owner, and a join key to navigate up the hierarchy to the logical database. This table enables you to inventory database schemas, analyze schema ownership, and walk the hierarchy (schema to logical database to database instance).

dd.postgres_schemas

Fields

TitleIDTypeData TypeDescription
Key_keycorestringUnique identifier for the PostgreSQL schema record.
Schema Nameschema_namecorestringName of the database schema.
Display Namedisplay_namecorestringHuman-readable display name for the schema.
OwnerownercorestringOwner of the schema.
IDidcorestringInternal identifier for the schema.
Postgres Logical Database Keypostgres_logical_database_keycorestringUsed to join this schema to dd.postgres_logical_databases to get logical database name and walk the hierarchy (schema to logical database to database instance).