Re: Feature request/suggestion - CREATE SCHEMA LIKE

wstrzalka wrote:
> Hi
>
>    Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
> are very usefull but it would be great to have such a feature on the
> mid-level too. I mean something CREATE SCHEMA LIKE that would copy all
> the template schema relations, etc...
>  What do you think about it ? Would it be hard to implement ? Is it
> worth the effort 
I believe the CREATE DATABASE was because of the way postgresql creates 
a database. I thought it just copied the template database (but are not 
completely sure). I also believe CREATE TABLE LIKE was mostly for 
temporary tables, where the query can not be sure what the table 
actually looks like when it is invoked.

Would it not be possible to work around the SCHEMA LIKE by just dumping 
the database schema and restoring it to a new schema? This seems more 
like a part that should be under strict user control and not automated 
by common queries.

- Joris