Re: pg_dumpall: does not exist database - Mailing list pgsql-general

Ari Kahn <akahn1@gmu.edu> writes:
> On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:
>> If so, I'm wondering if you've got a database with a carriage return
>> embedded in the name, or something like that.

> That was a good idea. But this is not the case.
> postgres=# drop database "\n";
> ERROR:  database "\n" does not exist
> postgres=# drop database "\r";
> ERROR:  database "\r" does not exist

Those tests have little to do with what I'm worried about.  Backslash
isn't an escape character in SQL names, and even if it were, your tests
only checked for databases named exactly "one newline" or "one carriage
return", not for names comprising those characters along with others.

            regards, tom lane