Mariusz =?iso-8859-2?q?Czu=B3ada?= <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org