Re: Add CREATE SCHEMA ... LIKE support

Hi Matheus

On 06/02/2026 15:22, Matheus Alcantara 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...]
>
> Where like_options is:
>   { INCLUDING | EXCLUDING } { TABLE | INDEX | ... | ALL }
>
> The idea of LIKE syntax is to create a new schema with all objects that
> exist on source schema like tables, indexes, sequences, functions,
> views, etc.

I generally like the idea.

One quick note:

I'm just wondering if using a similar syntax as IMPORT FOREIGN SCHEMA
would be better than creating a new one

IMPORT FOREIGN SCHEMA remote_schema
[ { LIMIT TO | EXCEPT } ( table_name [, ...] ) ]
FROM SERVER server_name
INTO local_schema
[ OPTIONS ( option 'value' [, ... ] ) ]

So EXCEPT instead of EXCLUDING and LIMIT TO instead of INCLUDING. Of
course, assuming the proposed syntax isn't already defined in the SQL
standard.

Best, Jim