From: | Ron Snyder <snyder(at)roguewave(dot)com> |
---|---|
To: | 'Jeff Beck' <jeff(dot)beck(at)mssm(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: psql -l gives bad output |
Date: | 2002-05-22 04:36:04 |
Message-ID: | F888C30C3021D411B9DA00B0D0209BE803BB99EC@cvo-exchange.cvo.roguewave.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> ---------------------------------+----------
> pay | postgres
> pay-test | postgres
> pay-test
> /usr/local/pgsql/bi | postgres
It looks to me like this 'second paytest' database is actually named
'pay-test\n/usr/local/pgsql/bi' , possibly created by trying to create a
database without having a closing quote:
User# createdb 'pay-test
(and then beginning to type some /usr/local/pgsql/bin command.)
The command dropdb doesn't seem (at least for me) to work the exact same
way, so the only way I could recover is the following:
(First create the problem)
bash-2.05$ createdb 'blah
> this is a test'
CREATE DATABASE
bash-2.05$ psql -l
List of databases
Name | Owner
---------------------+----------
blah
this is a test | pg721tmp
quickview | pg721tmp
template0 | pg721tmp
template1 | pg721tmp
(4 rows)
template1=# update pg_database set datname='foo' where datname like 'blah%';
UPDATE 1
bash-2.05$ psql -l
List of databases
Name | Owner
-----------+----------
foo | pg721tmp
quickview | pg721tmp
template0 | pg721tmp
template1 | pg721tmp
(4 rows)
-ron
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-22 04:56:59 | Re: psql -l gives bad output |
Previous Message | Roberto Andrade Fonseca | 2002-05-22 03:42:21 | Pgsql and the MARC standards |