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
