v.in.ogr's where clause cannot handle uppercase column names for Postgres
|Reported by:||arencambre||Owned by:|
In Postgres, if a column name has upper case characters, it must be surrounded by quote marks in SQL queries. If the column name is not surrounded by quote marks, it is interpreted as lower case.
For example, if Postgres sees SELECT * FROM x WHERE AAaa = 'hi', it looks for column aaaa, which is not the same as AAaa. If you want to match AAaa, you have to use SELECT * FROM x WHERE "AAaa" = 'hi'.
There appears to be no variant of escaping that works correctly with this with v.in.ogr's where parameter. For example, I have a column named Cnty_ID. I've tried all these variants of the where clause with no luck:
- "where="Cnty_ID" = '57'" -- translates to Cnty_Id = '57'.
- "where=\"Cnty_ID\" = '57'" -- translates to \Cnty_ID\ = '57'.
- where=""Cnty_ID" = '57'" -- translates to Cnty_Id = '57'.
- where="""Cnty_ID"" = '57'" -- translates to Cnty_Id = '57'.
The only documentation I could find on escaping in commands is at http://grass.osgeo.org/gdp/html_grass64/wxGUI.html.
This is happening on 6.4.1. (That option not available in the Version dropdown.)