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? Regards, --- Fernando Marcelo www.consultorpc.com ferna...@consultorpc.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
