TransWikia.com

PostgreSQL: Check the structure of foreign tables

Database Administrators Asked by Radu Dumbrăveanu on February 19, 2021

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).

One 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

Answered by Md Haidar Ali Khan on February 19, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP