Re: [GENERAL] Creating schema copy

2004-10-27 Thread Tom Lane
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 'defaul

[GENERAL] Creating schema copy

2004-10-27 Thread Mariusz Czułada
Hi, In a database I have to create new schemas with exactely the same structure as the default one. Of course, I could reverse a schema with pg_dump, then apply the script to the newly created one. The problem is the base schema sometimes changes so I should generate scripts every time. Also I