Re: [HACKERS] Re: [GENERAL] Variable case database names

On Thu, Jan 20, 2000 at 05:04:45PM -0500, Bruce Momjian wrote:
> [Charset ISO-8859-1 unsupported, filtering to ASCII...]
> > There is some code in libpq which converts all database names to
> > lower-case, unless it's double quoted. That seems a little ill-conceived
> > to me, since you'd actually have to pass it something like
> > PGconnectdb("dbname=\"Newnham\"");
> >
> > If anything, this would make it inconvenient it psql, because you'd have
> > to write
> > \c '"Newnham"'
> > since
> > \c "Newnham"
> > is interpreted differently.
> >
> > Does anyone have an explanation for this? Why not leave the name as is?
>
> We do the same thing with queries, right? We force identifiers to lower
> case unless quoted.

The point was: the database name was quoted. I didn't think to quote it
a second time. (single quoting for the create was sufficient, and the export
from access didn't mind about the case)

Cheers,

Patrick