How can I check if the structure of a foreign table was changed in the source database in order to know when to re import it. Foreign table was imported by foreign-data wrapper postgres_fdw (PostgreSQL 11.2).
2
-
What is the PostgreSQL version(x,y,z)?Md Haidar Ali Khan– Md Haidar Ali Khan2019-04-24 08:22:41 +00:00Commented Apr 24, 2019 at 8:22
-
PostgreSQL 11.2Radu Dumbrăveanu– Radu Dumbrăveanu2019-04-24 10:30:24 +00:00Commented Apr 24, 2019 at 10:30
Add a comment
|
1 Answer
How can I check if the structure of a foreign table was changed in the source database in order to know when to re import it. Foreign table was imported by foreign-data wrapper postgres_fdw.
As here and here if you’ve imported your schema, then you can query the foreign tables as if they were normal, local tables.
For further your ref postgres_fdw and IMPORT FOREIGN SCHEMA
-
1yes, I can query the content of foreign table as if it was normal, but can I query its structure? e.g. if in the original database somebody added/dropped/renamed a column to the table, can I get this (structural) information in the context of the database where this table is imported as a foreign table?Radu Dumbrăveanu– Radu Dumbrăveanu2019-04-24 11:24:05 +00:00Commented Apr 24, 2019 at 11:24