Re: Creating schema copy

#1

Mariusz =?iso-8859-2?q?Czu=B3ada?= <manieq (AT) idea (DOT) net.pl> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Creating schema copy

comp.databases.postgresql.general comp.databases.postgresql.general

Re: Creating schema copy - 10-27-2004 , 08:34 PM