Skip site navigation (1) Skip section navigation (2)

Re: Copy Schema

From: Keith Worthington <KeithW(at)NarrowPathInc(dot)com>
To: Derrick Betts <derrick(at)blueaxis(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy Schema
Date: 2006-07-28 16:28:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
>>> 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:
>> 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.
>Derrick Betts wrote:
> 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


There seems to be some confusion as to whether you want to create a new 
database with an existing schema or add a predefined schema to an 
existing database.

If the former then check out the docs at:
and try something like
   WITH TEMPLATE = mytemplatedb;

If the latter then check out the docs at:
and try something like
pg_dump --file=outfile.sql
to generate the schema commands and psql to run them in the target database.



Kind Regards,

In response to


pgsql-novice by date

Next:From: Derrick BettsDate: 2006-07-28 16:43:53
Subject: Re: Copy Schema
Previous:From: Derrick BettsDate: 2006-07-28 14:01:39
Subject: Re: Copy Schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group