idea Support Postgres tables with names in Mixed case in Data Management Ideas https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idi-p/934472 <P>I have some tables in a Postgres database, whose names are in mixed case. example: <STRONG>public."Building_Data"</STRONG><BR />ArcGIS desktop has trouble connecting to these tables, because their name is not in small letters. (See this forum post for more details: <A href="http://forums.arcgis.com/threads/82027-How-to-connect-to-Postgres-and-use-as-a-query-layer" target="_blank" rel="noopener">http://forums.arcgis.com/threads/82027-How-to-connect-to-Postgres-and-use-as-a-query-layer </A>) Other softwares do not have trouble with these kinds of tables, and ArcGIS should be able to work with them.</P><!-- content transformation source ID: 087E00000004bvW --> Fri, 09 Sep 2022 21:25:27 GMT DevdattaTengshe1 2022-09-09T21:25:27Z Support Postgres tables with names in Mixed case https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idi-p/934472 <P>I have some tables in a Postgres database, whose names are in mixed case. example: <STRONG>public."Building_Data"</STRONG><BR />ArcGIS desktop has trouble connecting to these tables, because their name is not in small letters. (See this forum post for more details: <A href="http://forums.arcgis.com/threads/82027-How-to-connect-to-Postgres-and-use-as-a-query-layer" target="_blank" rel="noopener">http://forums.arcgis.com/threads/82027-How-to-connect-to-Postgres-and-use-as-a-query-layer </A>) Other softwares do not have trouble with these kinds of tables, and ArcGIS should be able to work with them.</P><!-- content transformation source ID: 087E00000004bvW --> Fri, 09 Sep 2022 21:25:27 GMT https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idi-p/934472 DevdattaTengshe1 2022-09-09T21:25:27Z Re: Support Postgres tables with names in Mixed case https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idc-p/934473#M848 <HTML><HEAD></HEAD><BODY>The support for mixed case objects (tablenames, column names) should be supported for other databases (like DB2) as well. <!-- content transformation source ID: 00aE000000B2uBV --> </BODY></HTML> Fri, 13 Mar 2015 16:36:22 GMT https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idc-p/934473#M848 GregorMoehler 2015-03-13T16:36:22Z Re: Support Postgres tables with names in Mixed case https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idc-p/1224230#M2006 <P>Absolutely agree that if mixed case is supported in postgresql, then it sould also be supported in ArcGIS (as it is with SQL Server &amp; Oracle).</P><P>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!</P> Fri, 21 Oct 2022 14:02:09 GMT https://community.esri.com/t5/data-management-ideas/support-postgres-tables-with-names-in-mixed-case/idc-p/1224230#M2006 JohnFannon 2022-10-21T14:02:09Z