top of page
CerebroSQL

PostgreSQL:  

IMPORT FOREIGN SCHEMA

IMPORT FOREIGN SCHEMA remote_schema
[ { LIMIT TO | EXCEPT } ( table_name [, ...] ) ]
FROM SERVER server_name
INTO local_schema
[ OPTIONS ( option 'value' [, ... ] ) ]

Example

IMPORT FOREIGN SCHEMA foreign_films
FROM SERVER film_server INTO films;

IMPORT FOREIGN SCHEMA foreign_films LIMIT TO (actors, directors)
FROM SERVER film_server INTO films;

bottom of page