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