Support Postgres tables with names in Mixed case

536
2
04-12-2013 01:30 AM
Status: Open
Labels (1)
DevdattaTengshe1
New Contributor III
I have some tables in a Postgres database, whose names are in mixed case. example: public."Building_Data"
ArcGIS desktop has trouble connecting to these tables, because their name is not in small letters. (See this forum post for more details: http://forums.arcgis.com/threads/82027-How-to-connect-to-Postgres-and-use-as-a-query-layer ) Other softwares do not have trouble with these kinds of tables, and ArcGIS should be able to work with them.
2 Comments
GregorMoehler
The support for mixed case objects (tablenames, column names) should be supported for other databases (like DB2) as well.
JohnFannon

Mixed case objects should absolutely be supported (as they are in other DBs) if they are supported by the database. This issue is likely to affect and put off potential customers wishing to transition from Open Source (e.g. QGIS) to Esri.