Hubert (depesz) Lubaczewski • 4/9/2026

Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions

This article covers upcoming PostgreSQL 19 features: three new SQL-callable functions (pg_get_database_ddl(), pg_get_role_ddl(), pg_get_tablespace_ddl()) that return DDL statements needed to recreate databases, roles, and tablespaces. Each function supports optional parameters like pretty printing, including owner or tablespace, and role memberships. The functions require specific privileges and exclude sensitive data like passwords. This is a technical update for database administrators and developers working with PostgreSQL.

0 comments

#postgresql #Database Administration #SQL Functions