via something along the lines of

IMPORT FOREIGN SCHEMA

, or similar. One can implement

IMPORT FOREIGN SCHEMA

via the FDW API.