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.