Q:

ArcGIS not connecting to PostgreSQL db with all upper-case name

We've been trialling ArcGIS at work and are just about to buy. However, we have a PostgreSQL database which contains a lot of stuff we work with, which is named in all upper-case ("GISSTUFF", for instance). ArcGIS won't connect to it.
We've contacted the ESRI support desk and they say it needs renaming to lower-case. Which is easy enough to accomplish, but unfortunately throws out our other connections. GISSTUFF suddenly becomes gisstuff and their connections are lost.
And that's a lot of connections across a whole range of things. It can be managed, but we'd have to think of every point first where the connection would be, re-establish it and test it. I have no doubt that, since none of the staff here were the original system admins and documentation/training was sparse, things would fall through the gaps.
So, does anyone know of a way to make ArcGIS (just the standard Desktop stuff - I think that would be Pro nowadays) handle PostgreSQL databases in all upper-case?

A:

It is not possible to use ArcObjects to access databases (or tables, or columns) with mixed- or uppercase names.  ArcGIS Server, Desktop, and ArcPy are only capable of accessing objects with lowercase names.
The Desktop documentation states (emphasis mine):

Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lower case.

And the Server documentation says the same (ditto):

Use all lowercase characters for the login role; mixed and uppercase character names are not supported with ArcGIS.

With tables and columns, you can create views to work around naming issues.  But with databases, no connection is possible, so you never get that chance.

