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
ferna...@consultorpc.com

Can you connect to it?

--
Adrian Klaver
adrian.kla...@gmail.com

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.kla...@gmail.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to