Re: Add CREATE SCHEMA ... LIKE support

On Wednesday, February 11, 2026, Matheus Alcantara <matheusssilv97(at)gmail(dot)com>
wrote:

>
> I also want to mention that I don't think that we would be able to
> properly re-created 100% all objects from the source schema into the new
> schema. Some objects will be hard to copy and can still generate bougy
> objects like functions for example as David mention on [1] (we can
> support some kind of functions but some others will be hard).
>
> Another issue is to handle complex relations like the following:
> - Function A returns a boolean type
> - Custom DOMAIN type call function A on CHECK constraint
> - Function B return/use a type of custom DOMAIN
>
> What we should create first? It can have functions that depends on
> domains, so domains should be created first, but it can also have
> domains that depends on functions, so functions would need to be created
> first. This would be trick to fix.
>

This is a solved problem in pg_dump, no? It understands and follows the
dependency graph. Even allows schema-only dumps.

David J.