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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
