Paul M Foster <paulf@quillandmouse.com> writes:
>> That's normal. If you use quotes when you create the table, you (usually)
>> need quotes when accessing the fields. If you don't use quotes when creating
>> the table, you don't need them when accessing.
> Huh? Doesn't the parser strip off the quotes? Are you saying it stores
> the quotes and expects you to provide them when accessing the fields?
No; the above is just a rule of thumb for staying out of case-folding
trouble, which is what seems to be biting you. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
and pay particular attention to the footnote ...
regards, tom lane