Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement

Nishant Sharma <nishant.sharma@enterprisedb.com>

From: Nishant Sharma <nishant.sharma@enterprisedb.com>

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

Cc: Jim Jones <jim.jones@uni-muenster.de>, Manni Wood <manni.wood@enterprisedb.com>, pgsql-hackers@postgresql.org

Date: 2025-11-05T11:53:57Z

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_tablespace_ddl() function
- b99fd9fd7f36 19 (unreleased) landed
Split out innards of pg_tablespace_location()
- 877a024902a7 19 (unreleased) landed
Remove spclocation field from pg_tablespace
- 16d8e594acd9 9.2.0 cited

Attachments

v5-0001-Supporting-changes-for-pg_get_tablespace_ddl-func.patch (application/octet-stream) patch v5-0001
v5-0002-Adds-pg_get_tablespace_ddl-function.patch (application/octet-stream) patch v5-0002

Thanks Álvaro for the review comments on v4!

PFA, v5 patch set. I have included all your review comments.


Regards,
Nishant Sharma.
EDB, Pune.
https://www.enterprisedb.com