Joris Dobbelsteen wrote: > 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.
No one has actually asked for CREATE SCHEMA LIKE before but we could add it to the TODO list if we can find a few people who want the feature. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
