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

Copy Schema

From: "Derrick Betts" <derrick(at)blueaxis(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Copy Schema
Date: 2006-07-28 05:09:32
Message-ID: 061701c6b204$04c15430$0202a8c0@main (view raw or flat)
Thread:
Lists: pgsql-novice
Is there a way to create a "template" schema, similar to modifying the template1 to use for new database creation?

I'm trying to get consistent tables and all other metadata set in one schema and then use that schema as a template for creating other schemas in the same database as needed.

I read that there is a way to restore a schema with pg_restore command.  Is the best or only way to accomplish this?

Thank you,
Derrick Betts

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2006-07-28 06:22:10
Subject: Re: Copy Schema
Previous:From: Andrew HammondDate: 2006-07-27 19:59:50
Subject: Re: query help

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