[GENERAL] copy template X - Y

2006-11-15 Thread jef peeraer

is it possible to copy one template, say X to a new template , called Y ?
Or better, i want a sort of a basic template that can be used to create 
a new schema.



jef

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [GENERAL] copy template X - Y

2006-11-15 Thread Alban Hertroys
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
[EMAIL PROTECTED]

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 //

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings