Re: dropping template1

From: "Tom" <tom(at)minnesota(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: dropping template1
Date: 2003-01-09 16:21:09
Message-ID: 3816.63.226.186.156.1042129269.squirrel@mail.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Thu, 2003-01-09 at 02:40, Thomas T. Thai wrote:
>> there are lots of functions and datatypes etc. is there an easier way?
>
> Try this:
>
> (1) UPDATE pg_database SET datistemplate = false WHERE datname =
> 'template1';
[...]

That was exactly what I was looking for. Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Konzack 2003-01-09 16:26:19 Re: How to backup a postgreSQL of 80 GByte ?
Previous Message Adam Witney 2003-01-09 16:03:14 Using crosstab in tablefunc