Re: copy template X -> Y - Mailing list pgsql-general

From Alban Hertroys
Subject Re: copy template X -> Y
Date
Msg-id 455B0823.6000001@magproductions.nl
Whole thread Raw
In response to copy template X -> Y  (jef peeraer <jef.peeraer@telenet.be>)
List pgsql-general
jef peeraer wrote:
> is it possible to copy one template, say X to a new template , called Y ?

CREATE DATABASE Y TEMPLATE X;

> Or better, i want a sort of a basic template that can be used to create
> a new schema.

A template for a schema... Not directly AFAIK, but you can write SQL
files to generate your schema contents. Don't forget to set your
search_path before executing it though. Something like:

BEGIN;
CREATE SCHEMA test;
SET search_path TO test;
\i schema_template.sql
-- And if you're satisfied with the results
COMMIT;

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: jef peeraer
Date:
Subject: copy template X -> Y
Next
From: Chris Mair
Date:
Subject: Re: The old Insert and retrieving your Serial problem in