Horton
Menu

Re: dropping template1

Thomas T. Thai <tom@minnesota.com>

View thread
From: "Tom" <tom@minnesota.com>
To: <pgsql-general@postgresql.org>
Date: 2003-01-09T16:21:09Z
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.