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.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.