Re: Creating schema copy

Mariusz =?iso-8859-2?q?Czu=B3ada?= <manieq(at)idea(dot)net(dot)pl> writes:
> My question: is it possible to extend (in near future) CREATE SCHEMA syntax
> with feature like:
> CREATE SCHEMA user_xxx_schema FROM default_user_schema [WITH CONTENT];
> ?
> It should create *every* object existing in 'default_user_schema' in
> 'user_xxx_schema' preserving of course names, constraints, triggers, etc.
> Optionally it could also copy table contents (but this is not very
> important).

AFAICS this would require a code body approximately as large,
complicated, and maintenance-needy as pg_dump itself; and being inside
the backend, it could share little or no physical code with pg_dump.

So no, it's not very likely to happen in the near future. pg_dump is
your best bet.

regards, tom lane