Re: Add CREATE SCHEMA ... LIKE support

On 06/02/26 12:19, Marcos Pegoraro wrote:
>> I'd like to propose the introduction of the LIKE syntax on CREATE SCHEMA
>> command with the following syntax:
>>    CREATE SCHEMA <name> LIKE <source_schema> [like_options...
> 
> 
> This feature is really cool.
> Having a function to clone schemas is what we use for these cases, so it
> would be very interesting to have a command that replaces that function.
> One observation is that you are using CREATE TABLE ... LIKE and this
> command does not respect some object names, like indexes and constraints.
> Your example idx_t1_name will clone as t1_name_idx
> 
> So the cloned schema will not be exactly the same as the source.
> Maybe a rename process to match names from source to target next to CREATE
> TABLE LIKE would solve those cases.
> 

Thanks for the input. I'll think about how to fix this for the next 
version.

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