Re: Add CREATE SCHEMA ... LIKE support

On 12/02/26 17:27, Marcos Pegoraro wrote:
> Em qui., 12 de fev. de 2026 às 13:40, Jim Jones <jim.jones@uni-muenster.de>
> escreveu:
> 
>> What do you think about introducing a clause similar to COPY .
> 
> 
> A schema can have thousands of objects, and that schema will be ok only if
> all objects are copied.
> It will be very difficult for the user to see which ones were not copied.
> 
> I think the whole process should be done or raise an exception. Ignoring
> items I don't think is fine.
> 

Yeah, I agree. I think that we can be less restrictive. The behavior 
can be to allow reference objects from schemas different than source 
and in case some error happen it stop the process. This behavior 
should be documented.

In case of e.g table partitions which the parent is in different 
schema the overlap error will happen and the the process will stop. 
For another cases like types in different schema it will work normally.

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