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