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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
