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.
Absolutely agree that if mixed case is supported in postgresql, then it sould also be supported in ArcGIS (as it is with SQL Server & Oracle).
This is especially problematic for customers who are transitioning to Esri from open source solutions and we have recently had to go through the painful process of renaming db objects for one customer, just so that ArcGIS will recognise them. Not a good start to their Esri experience!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.