There was a discussion on -interfaces that might need more consideration.
http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00026.php
Apparently, it has so far been an undocumented feature of libpq's function
PGfnumber (return column number from column name) that the column name
needs to be double-quoted if it contains upper-case letters. That, is you
need to write
PQfnumber(res, "\"Bar\"")
I think this is completely bizarre and pointless. This is a C interface
and not SQL. Other libpq functions that accept names of SQL objects don't
do this. Also, PQfname and PQfnumber ought to be inverses.
Since this behavior was undocumented and no one had noticed it in the last
10 years, I think we can away with removing it.
--
Peter Eisentraut peter_e@gmx.net