---
title: PostgreSQL Schemas
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > PostgreSQL Schemas
---

# 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

| Title                         | ID                            | Type | Data Type | Description                                                                                                                                                      |
| ----------------------------- | ----------------------------- | ---- | --------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Key                           | _key                          | core | string    | Unique identifier for the PostgreSQL schema record.                                                                                                              |
| Schema Name                   | schema_name                   | core | string    | Name of the database schema.                                                                                                                                     |
| Display Name                  | display_name                  | core | string    | Human-readable display name for the schema.                                                                                                                      |
| Owner                         | owner                         | core | string    | Owner of the schema.                                                                                                                                             |
| ID                            | id                            | core | string    | Internal identifier for the schema.                                                                                                                              |
| Postgres Logical Database Key | postgres_logical_database_key | core | string    | Used 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). |