Community
Select to view content in your preferred language

Much Broader Support for PostgreSQL and PostGIS

94
3
Tuesday
Status: Open
Labels (1)
ack_ack_ack_ack
by
Occasional Contributor

ArcGIS has two(?) methods of connecting to an external database.

One is https://pro.arcgis.com/en/pro-app/3.3/help/data/databases/database-connections-in-arcgis-pro.htm  This doesn't work with any tools in ArcGIS.

 

Another is query layer: https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm  

It's unclear what the difference is and, since none of the other tools work, seems like lots of features to build.

Tags (2)
0 Kudos
3 Comments
ChrisUnderwood
by Esri Regular Contributor
Wednesday

Hello @ack_ack_ack_ack , data loaded into ArcGIS Pro through a Database Connection should work with most of the tools in ArcGIS. Are you able to post any screenshots or examples of what you see when it "doesn't work" ?

VinceAngelo
by Esri Esteemed Contributor
Wednesday

I've been using PostgreSQL/PostGIS with ArcGIS clients since at least PG 8.0, probably to PG 7.something_small. Desktop clients have supported direct write to even non-enabled PostgreSQL instances since  ArcGIS 10.4.1.  All the ArcGIS Pro releases have supported at least three PostgreSQL releases, sometimes as many as five.

Instead of filing an enhancement request to do what the software already has done for two decades, you'd probably be better served by asking a specific question about your particular use case. Critical information includes:

  • The exact PostgreSQL release
  • The database name and table owner name
  • The exact command you're using
  • The exact error or other problem encountered

It's not like there aren't some quirks to how PostgreSQL is supported, but it's not all that difficult to get full functionality, both with and without geodatabase enablement.

- V