Re: Table appears on listing but can't drop it - Mailing list pgsql-general

Adrian Klaver <adrian.klaver@gmail.com> 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