fdw.sql

CREATE SCHEMA staging;
CREATE EXTENSION postgres_fdw;
CREATE SERVER staging FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'hostname', dbname 'dbname', port'5432');
CREATE USER MAPPING FOR CURRENT_USER SERVER staging OPTIONS (user 'username', password 'password');
IMPORT FOREIGN SCHEMA public FROM SERVER staging INTO staging;

-- CREATE TABLE public.lol AS SELECT * from staging.users where <whatever>...