On 12/10/07, Ted Byers <r.ted.byers@xxxxxxxxxx> wrote: > > Where will I find template1? When I look at the > databases on the server, the only template I see is > called "template_postgis". Most of the extra stuff I > see in all my databases relates to geometry that I > find in this template. When I installed postgresql, I > enabled postgis because I need it for some, but not > all, of my databases. Is it possible to have more > than one template, and to specify which template to > use when creating a new DB? Yes, looking at the docs for CREATE DATABASE would probably be enlightnening for you. -Doug ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
