Andreas Langegger <al(at)jku(dot)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