Re: [GENERAL] Feature request/suggestion - CREATE SCHEMA LIKE

[Decibel!]

On Mar 18, 2008, at 7:17 AM, Joris Dobbelsteen wrote:

   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

the template schema relations, etc...
 What do you think about it ? Would it be hard to implement ? Is it
worth the effort

mid-level too. I mean something CREATE SCHEMA LIKE that would copy all

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).

--
Decibel!, aka Jim C. Nasby, Database Architect  [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828

You are correct. This is why the database used as a template can't have anyone connected to it; if somebody was, we can't get a consistent filesystem-level copy of the database.

smime.p7s
Description: S/MIME cryptographic signature