Em 08/01/2010, às 14:48, Tom Lane escreveu: > Adrian Klaver <adrian.klaver@xxxxxxxxx> writes: >> On 01/08/2010 08:39 AM, Fernando Morgenstern wrote: >>> Name | Owner | Encoding | Collation | Ctype | Access privileges >>> -----------+----------+----------+-------------+-------------+----------------------- >>> skynet | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>> t1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | >>> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>> : postgres=CTc/postgres >>> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres >>> : postgres=CTc/postgres > >> You have a space at the beginning of the name. Try: >> drop database " skynet"; > > I'm not sure about that, because the whole row seems to be offset in > his email. That could be just copy-and-paste sloppiness. Still, > some sort of non-printing character in the name seems to be indicated, > else he'd not have been able to create another db with name "skynet". > > Try something like > select '"' || datname || '"' from pg_database > to get a clearer view of what's really in there. > > regards, tom lane 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
