From: | Marcos Lloret <marcos(at)second(dot)ival(dot)es> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | existing but not-existing database. |
Date: | 2000-06-08 11:32:54 |
Message-ID: | 393F8465.D91CE0E5@second.ival.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
i created a database called todojamon. (i wanted to make up of an
old database trying to copy the same directoy to ../base/todojamon as
before). but it does not work. i deleted the directory. now i want to
restart the procedure creating a new database called todojamon. but it
answers
> psql todojamon
FATAL 1: Database 'todojamon' does not exist.
We know this because the directory
'/usr/local/pgsql/data/base/todojamon' does not exist.
You can create a database with the SQL command CREATE
DATABASE.
To see what databases exist, look at the subdirectories of
'/usr/local/pgsql/data/base/'.
Connection to database 'todojamon' failed.
FATAL 1: Database 'todojamon' does not exist.
We know this because the directory
'/usr/local/pgsql/data/base/todojamon' does not exist.
You can create a database with the SQL command CREATE
DATABASE.
To see what databases exist, look at the subdirectories of
'/usr/local/pgsql/data/base/'.
if
> psql template1
[inside postgres]
template1=> create database todojamon;
ERROR: createdb: database 'todojamon' already exists
ERROR: createdb: database 'todojamon' already exists
how can i delete todojamon database??
thanks in advance.
marcos
marcos(at)ival(dot)es
From | Date | Subject | |
---|---|---|---|
Next Message | mikeo | 2000-06-08 12:20:10 | Re: Re: [SQL] oracle rownum equivalent? |
Previous Message | Paulo Jan | 2000-06-08 11:15:41 | Re: existing but not-existing database. |