Re: BUG #2598: Columns named R are not accessible - although R is not a keyword

Andreas Langegger <al@jku.at> writes:
> Well, I also tried your simple regression test and it worked. The more
> I'm wondering why this does not:

> CREATE TABLE sunspots
> ...
>   "R" int2,

"R" with double quotes represents capital R, but when you write R
without quotes in a query, it's implicitly downcased.  See
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

If you spell it like that in the table definition then you'll need
to use quotes every time you refer to the column, too.

            regards, tom lane