I know how to create new databases by using the template1 already. I want
to create new schemas with the requirements outlined in the original email.
----- Original Message -----
From: "Michael Glaesemann" <grzm(at)seespotcode(dot)net>
To: "Derrick Betts" <derrick(at)blueaxis(dot)com>
Sent: Friday, July 28, 2006 12:22 AM
Subject: Re: [NOVICE] Copy Schema
> On Jul 28, 2006, at 14:09 , Derrick Betts wrote:
>> Is there a way to create a "template" schema, similar to modifying the
>> template1 to use for new database creation?
> Certainly. Any database can be used as a template. template1 is used by
> default. Check out the CREATE DATABASE docs:
>> I read that there is a way to restore a schema with pg_restore command.
>> Is the best or only way to accomplish this?
> Well, if you haven't loaded data into a database you want to use as a
> template (or it only has data you want to include in the new database),
> you can use CREATE DATABASE as well.
> Hope this helps.
> Michael Glaesemann
> grzm seespotcode net
In response to
pgsql-novice by date
|Next:||From: Keith Worthington||Date: 2006-07-28 16:28:32|
|Subject: Re: Copy Schema|
|Previous:||From: Kaloyan Iliev||Date: 2006-07-28 13:33:59|
|Subject: Tables Locks Quetion or Strictlly subsequent numbers|