On 01/08/2010 09:53 AM, Fernando Morgenstern wrote:
Em 08/01/2010, às 15:49, Adrian Klaver escreveu:
On 01/08/2010 08:55 AM, Fernando Morgenstern wrote:
Hello,
Thanks for your quick answers. The extra space is indeed a copy-and-paste issue. Here it is the select that you suggested:
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"t1"
"skynet"
Best Regards,
---
Fernando Marcelo
www.consultorpc.com
fernando@xxxxxxxxxxxxxxx
Can you connect to it?
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
No, i get this:
$ psql skynet
psql: FATAL: database "skynet" does not exist
I can create a database with the same name:
postgres=# create database skynet;
CREATE DATABASE
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"postgres"
"t1"
"skynet"
"skynet"
And drop the newly created database:
postgres=# drop database skynet;
DROP DATABASE
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"postgres"
"t1"
"pgpool"
"skynet"
Strange, isn't it?
Actually what is strange is that your previous listing :
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"t1"
"skynet"
is not the same as the one above:
postgres=# select '"' || datname || '"' from pg_database;
?column?
-------------
"template1"
"template0"
"postgres"
"t1"
"pgpool"
"skynet"
In particular the presence of postgres,t1 and pgpool.
Are you sure which cluster you are pointing at and whether the psql
version matches the server version?
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
