Read foreign tables from Postgres/Postgis

824
1
04-18-2019 10:48 AM
Status: Open
Labels (1)
CarlStewart
New Contributor II

ArcGIS does not read foreign tables from a Postgres database.  Since this includes views built from those tables, it becomes difficult to use this data in Arc.  Currently the only way to see these tables is via a Postgres materialized view - which renders it static.

 

It would be very useful to be able to interact directly with foreign tables in the same way as any other data it contains.

1 Comment
PierreloupDucroix

I agree it would be easier to communicate between postgres databases.

However, a workaround exists -> create a view based on the foreign table in pgadmin, then register the view in AGPro.

It works well for me (at least with read only)