Re: Add CREATE SCHEMA ... LIKE support

On 06/02/26 12:30, David G. Johnston wrote:
> On Friday, February 6, 2026, Matheus Alcantara <matheusssilv97@gmail.com>
> wrote:
> 
>>
>> I'm attaching a PoC patch that implements the LIKE syntax for tables and
>> indexes. I would like to start a discussion to see if this feature make
>> sense and if it could be useful to have at core. I have intention to add
>> support for more objects(sequence, functions, ...) in future patches if
>> It makes sense.
>>
> 
> I’d suggest you solve the functions cloning first to make sure that won’t
> end up being a blocker.  SET clauses in particular, and “atomic” functions,
> seem non-trivial to deal with.  Views too really, depending on the approach.
> 
Thanks for the call. I'll focus on these for the next version.

> More generally maybe start with the documentation to define exactly how it
> should behave and what limitations it would have (i.e., it isn’t going to
> re-point schema references in black-box function bodies).
> 
Good point, I'll also include some initial documentation changes on 
the next version.

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