cannot add postgres view to arcgis desktop

Question

cannot add postgres view to arcgis desktop

smnorris opened this issue 6 years ago · 2 comments

On ArcGIS 10.1 - perhaps this isn't an issue for current versions but it could be valuable to write whse_fish.fiss_fish_obsrvtn_events_vw as a table or maybe materialized view

Answer 1 · 2020-02-28T23:02:21.000Z

For QGIS it seems the issue was that the Geometry types have to be exactly defined. A view is displayed in the browser window if the point geom is coerced: ::geometry(Point, 3005) in the query that defines the view/materialized view.

Answer 2 · 2020-06-01T00:23:12.000Z

Looks like it was the same issue with Arc.