Demo of postgres_fdw to "tunnel" access to a remote table;

postgres_fdw.sql

create extension postgres_fdw ;
create server dev foreign data wrapper postgres_fdw  options (host 'localhost', dbname 'db_dev');
select user;
create user mapping for my_user server dev  options (user 'my_user' );
create schema dev;
import foreign schema public limit to ( table_to_copy ) from server dev into dev;
select * from dev.table_to_copy;