On Mar 31, 5:01 pm, l...@blueaxis.com (Derrick Betts) wrote:
(...)
> I'm not an expert, however, your SQL query may need the double quotes
> around the field names and table name. Your table definition created
> the field names and table names with double quotes, therefore your SQL
> query must call those field names and table names with the double quotes
> as well.
Actually, this is not exact. Here is, what double quotes do
http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
In the example above "organization" is a non-reserved word in lower
case, so the double-quotes do nothing.
Jeanie might erroneoulsy have used mixed-case in creating the object.
Like: CREATE TABLE "Organization" ...
That would explain everything, of course.
Personally, I would refrain from using identifiers that need double-
quoting to begin with. Makes your life easier.
Regards
Erwin