OpenMetadata/openmetadata-docs/content/partials/v1.8/connectors/database/postgres/reverse-metadata.md

Reverse Metadata

Description Management

PostgreSQL supports description updates at all levels:

• Database level
• Schema level
• Table level
• Column level

Owner Management

PostgreSQL supports owner management at the following levels:

• Database level
• Schema level
• Table level

Tag Management

❌ Tag management is not supported for PostgreSQL.

Custom SQL Template

PostgreSQL supports custom SQL templates for metadata changes. The template is interpreted using python f-strings.

Here are examples of custom SQL queries for metadata changes:

-- Update database owner
ALTER DATABASE {database} OWNER TO {owner};

The list of variables for custom SQL can be found here.

For more details about reverse metadata ingestion, visit our Reverse Metadata Documentation.

Requirements for Reverse Metadata

In addition to the basic ingestion requirements, for reverse metadata ingestion the user needs:

• SUPERUSER privilege to the user

-- Grant superuser privilege to the user
ALTER ROLE USER_NAME SUPERUSER;