Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement

Álvaro Herrera <alvherre@kurilemu.de>

From: Álvaro Herrera <alvherre@kurilemu.de>

To: Akshay Joshi <akshay.joshi@enterprisedb.com>

Cc: Chao Li <li.evan.chao@gmail.com>, Japin Li <japinli@hotmail.com>, Quan Zongliang <quanzongliang@yeah.net>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2025-11-19T10:47:43Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add infrastructure for pg_get_*_ddl functions
- 4881981f9202 19 (unreleased) landed
Add pg_get_database_ddl() function
- a4f774cf1c7e 19 (unreleased) landed
Add new OID alias type regdatabase.
- bd09f024a1bb 19 (unreleased) cited

Hello,

One thing I realized a few days ago is that since commit bd09f024a1bb we
have type regdatabase, so instead of having two functions (one taking
name and one taking Oid), we should have just one, taking regdatabase,
just like the functions for producing DDL for other object types that
have corresponding reg* type.

Regards,

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/