| 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: | Whole Thread | Raw Message | 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. |