On Sat, 3 Jul 2004, Dennis Gearon wrote:
> Stephan Szabo wrote:
>
> > IIRC, psql (and the createuser shell script and such) treat it as if you
> > had double quoted its argument because of the way shells handle quotes
> > which would necessitate something like '"FOO"' to use a quoted uppercase
> > name. So, if you say psql FOO -U BAR, you're saying log into database
> > "FOO" as user "BAR".
> >
> >
> I created the user from inside of a psql session.
>
> And I cannot either connect from invoking a different psql session from the shell,
> nor from PHP using it's compiled in c library for postgres.
>
> It seems it's another gotcha with this database. I wouldn't have thought
> it would so difficult to insert upper(whatever was enterd) into the
> database, and validate it the same way.
Create user Foo and Create user "Foo" are creating users with different
names. Since we want to allow both names to exist at the same time and for
you to refer to either, there needs to be a mechanism for doing so. I
don't know about PHP, but as I said above, psql does not treat its
arguments as normal identifiers (thus lowercasing them) because it was
decided to be simpler for people to refer to either user. For the former,
it is foo and the latter Foo.