Re: DROP DATABASE, but still there

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DROP DATABASE, but still there
Date: 2004-11-11 20:17:13
Message-ID: 87ekj0dtti.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Robert Fitzpatrick <robert(at)webtent(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-11-11 20:17:50 Re: When to switch to Postgres 8.0?
Previous Message Greg Stark 2004-11-11 20:15:34 Re: implicit casting problem