Re: Add CREATE SCHEMA ... LIKE support

Em sex., 6 de fev. de 2026 às 11:22, Matheus Alcantara <
matheusssilv97(at)gmail(dot)com> escreveu:

> 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.

regards
Marcos