Re: copy template X -> Y

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