Re: Recreate database but old tables still present

Le 24/02/2011 16:49, gvim a écrit :
> PostgreSQL 9.0.3/Mac OS X 10.6.6
>
> I need to recreate a database at regular intervals and what normally
> works is:
>
> user$: dropdb -U myuser -h localhost mydb;
>
> user $: psql -U myuser -h localhost mydb;
> psql: FATAL: database "mydb" does not exist
>
> user$: createdb -U myuser -h localhost mydb;
>
> Now, for some reason, when I recreate the datbase the old tables are
> still present. I've tried the same procedure using a psql login but the
> result is the same.
>

You probably created your tables in the template1 database. Check this
database if they appear here too.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com