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