# pg\_get\_database\_ddl

Published articles for pg\_get\_database\_ddl.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Waiting for PostgreSQL 19 - new pg\_get\_\*\_ddl() functions

DevFeed: [Waiting for PostgreSQL 19 - new pg\_get\_\*\_ddl() functions](<https://devfeed.tech/articles/waiting-for-postgresql-19-new-pg-get-ddl-functions-33686.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/04/09/waiting-for-postgresql-19-new-pg_get__ddl-functions/>)

Author: depesz

Published: 2026-04-09T16:37:45Z

Content type: article

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [functions](<https://devfeed.tech/tags/functions.md>), [pg-dump](<https://devfeed.tech/tags/pg-dump.md>), [pg-get-database-ddl](<https://devfeed.tech/tags/pg-get-database-ddl.md>), [pg-get-role-ddl](<https://devfeed.tech/tags/pg-get-role-ddl.md>), [pg-get-tablespace-ddl](<https://devfeed.tech/tags/pg-get-tablespace-ddl.md>), [pg19](<https://devfeed.tech/tags/pg19.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [waiting](<https://devfeed.tech/tags/waiting.md>)

### AI overview

This article examines proposed PostgreSQL 19 SQL-callable pg_get_*_ddl() functions that generate DDL for recreating databases, roles, and tablespaces. It demonstrates their output and options, notes that role passwords are not exported, and observes that support for additional object types is still missing.

### Source excerpt

On 5th of April 2026, Andrew Dunstan committed patch: Add pg_get_database_ddl() function Add a new SQL-callable function that returns the DDL statements needed to recreate a database. It takes a regdatabase argument and an optional VARIADIC text argument for options that are specified as alternating name/value pairs. The following options are supported: pretty (boolean) ... Continue reading "Waiting for PostgreSQL 19 - new pg_get_*_ddl() functions"