postgres_fdw setup

-- creates fdw to the database quotes in a schema quotes_s

create extension if not exists postgres_fdw;

create server prod_s foreign data wrapper postgres_fdw options (host 'servername', dbname 'quotes', port '5432');

create user mapping for public server prod_s options (user 'name', password 'secret'); 

create schema quotes_s;

import foreign schema public from server prod_s into quotes_s;

commit;