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/