Read foreign tables from Postgres/Postgis

CarlStewart — Wed, 05 Oct 2022 23:28:46 GMT

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.

Re: Read foreign tables from Postgres/Postgis

PierreloupDucroix — Fri, 26 Feb 2021 03:26:26 GMT

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)

idea Read foreign tables from Postgres/Postgis in Data Management Ideas

Read foreign tables from Postgres/Postgis

Re: Read foreign tables from Postgres/Postgis