Re: Mysterious empty database name?

Excerpts from Azlin Rahim's message of mar may 25 18:23:13 -0400 2010:
> In our database list, there is one 'mysterious' database with a blank name.
> We don't know how it got there.

Maybe somebody SQL-injected you and created it.

> Below is the output of pg_database. Does anyone have any idea why this is
> happening? Any way to remove the 'mysterious' database safely.

I'd investigate a bit more what's inside, before deleting it. Maybe the
name has only whitespace or control chars. You can use double quotes to
refer to such names. For example, this is a name a space and a
backspace:

=# create database " ^?";
CREATE DATABASE

You can see the ASCII chars that make up the name with something like this:

=# select datname, ascii(substring(datname, generate_series(1, length(datname)), 1)) from pg_database;

\x7F | 32
\x7F | 127

Now if somebody messed with an Unicode control char, I don't know what
to tell you.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support