Re: Add CREATE SCHEMA ... LIKE support

Hello,

On 2026-Feb-06, Matheus Alcantara wrote:

> I was reading the TODO wiki page and found the "Add CREATE SCHEMA ...
> LIKE that copies a schema" item and I thought that it could be a good
> idea to have this at core.

Egad. A TODO thing from way back which probably doesn't make much sense
nowadays, or at least so I think.

This whole thing seems like a giant can of worms, and I'm not sure it's
a good idea to add DDL syntax for it. I didn't read the thread in
detail, but the discussions downthread about adding weird clauses to
CREATE SCHEMA look quite worrisome.

Why not try to devise a way to reuse the DDL functions being proposed in
various nearby pgsql-hackers threads? There are a bunch of such patches
in the commitfest already; it's probably easy to have a way to generate
a list of objects in a schema, then call the DDL function corresponding
to each object type for each object, and then you're done.

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