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
>
On Feb 24, 2011, at 9:19 PM, gvim wrote:
> 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.
This can happen if template1 database has those tables. Check/verify if those
table
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, fo
