Re: Copy Schema - Mailing list pgsql-novice

From Derrick Betts
Subject Re: Copy Schema
Date
Msg-id 067001c6b24e$5cb2e920$0202a8c0@main
Whole thread Raw
In response to Copy Schema  ("Derrick Betts" <derrick@blueaxis.com>)
Responses Re: Copy Schema
List pgsql-novice
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
>
>
>
>



pgsql-novice by date:

Previous
From: Kaloyan Iliev
Date:
Subject: Tables Locks Quetion or Strictlly subsequent numbers
Next
From: Keith Worthington
Date:
Subject: Re: Copy Schema