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.
Any thoughts?
Derrick
----- Original Message -----
From: "Michael Glaesemann" <grzm@seespotcode.net>
To: "Derrick Betts" <derrick@blueaxis.com>
Cc: <pgsql-novice@postgresql.org>
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:
>
> http://www.postgresql.org/docs/current/interactive/sql-
> createdatabase.html
>
>> 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
>
>
>
>