Re: Add CREATE SCHEMA ... LIKE support

On Thu Feb 12, 2026 at 5:38 PM -03, Álvaro Herrera 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.

IIUC you'are suggesting to have something like pg_get_schema_ddl() which
would return the CREATE SCHEMA command and the DDL command used to
create the objects within the schema?

If that's the point it's sounds a better way to implement this. At some
point when I was writing the last version I thought that if we have
these patches already merged this LIKE clause could be implemented
easier but I was thinking to reuse with the LIKE clause, but creating a
function to get a schema definition seems more reasonable and follow the
same pattern for these other patches.

Thanks for the comments.

--
Matheus Alcantara
EDB: https://www.enterprisedb.com