Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP DATABASE, but still there - Mailing list pgsql-general

From Greg Stark
Subject Re: DROP DATABASE, but still there
Date
Msg-id 87ekj0dtti.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: DROP DATABASE, but still there  (Robert Fitzpatrick <robert@webtent.com>)
Responses Re: DROP DATABASE, but still there
List pgsql-general
Tree view 
Robert Fitzpatrick <robert@webtent.com> writes:

> Yeah, I was just starting to realize that these objects that keep coming
> back are in the template1 as well.....any reason why I shouldn't drop
> the template1 and re-create like any other?

You can do that but you'll have to do:

  CREATE DATABASE template1 WITH template = 'template0'


--
greg

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: implicit casting problem
Next
From: Andrew Rawnsley
Date:
Subject: Re: comp.database.postgresql.*