Re: solution to Delete databases and tables - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: solution to Delete databases and tables
Date
Msg-id 20050323134410.GA42965@winnie.fuhr.org
Whole thread Raw
In response to solution to Delete databases and tables  ("Cima" <ruel.cima@facinf.uho.edu.cu>)
List pgsql-novice
On Wed, Mar 23, 2005 at 03:41:37AM -0500, Cima wrote:

> the folowing command did the trick: createdb -T template0 dbname
>
> this should be executed .../pgsql/createdb -T template0 dbname.
>
> now my databases are clean and empty, the old table no longer appear.

You might want to consider cleaning up template1 so you don't have
to specify template0 every time you create a new database.  In
general, you shouldn't be doing any work in template1 since it's
the default template database.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: Gordon Haverland
Date:
Subject: Re: pgsql.so
Next
From: "Jon Allen"
Date:
Subject: 8.0 installs ok, but then...