Select to view content in your preferred language

Support Postgres tables with names in Mixed case

1199
3
04-12-2013 01:30 AM
Status: Closed
Labels (1)
DevdattaTengshe1
Deactivated User
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.
3 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.

SSWoodward
Status changed to: Closed

This idea has been closed as a duplicate of the Data Management Idea linked below. Don't worry, you can still show your support by commenting and adding kudos to the open idea. Thanks for your contributions!

https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case...