Re: Quotes in SQL

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