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.