Re: 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