Re: Add CREATE SCHEMA ... LIKE support

On Fri, Feb 06, 2026 at 04:23:45PM +0100, Jim Jones wrote:
>
>
> On 06/02/2026 15:42, Matheus Alcantara wrote:
> > On 06/02/26 11:35, Jim Jones wrote:
> >> 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.
> >>
> >
> > Yeah, it could be an option but IMHO adding the LIKE on CREATE SCHEMA
> > sounds more similar to what we already have for CREATE TABLE ... LIKE.
> >
> > Although I prefer the CREATE SCHEMA LIKE syntax I'm open to discuss
> > about other syntaxes.
>
> Just to be clear, I also like the CREATE SCHEMA <name> LIKE
> <source_schema> syntax. I was just suggesting to consider changing
> EXCLUDING and INCLUDING to EXCEPT and LIMIT TO, respectively. Just to
> make it more consistent with IMPORT FOREIGN SCHEMA, although I find
> INCLUDING and EXCLUDING way more intuitive :)

The way I see it EXCLUDING and INCLUDING are for TYPES of objects (like:
EXCLUDING indexes), while EXCEPT and LIMIT TO are for specific objects
(EXCEPT users).

Best regards,

depesz