describes how to configure a foreign table in postgres

Foreign table postgres

create extension postgres_fdw;

CREATE SERVER postgres_2
 FOREIGN DATA WRAPPER postgres_fdw
 OPTIONS (dbname 'db_2', host '172.17.0.4', port '5432');
 
CREATE USER MAPPING FOR CURRENT_USER
  SERVER postgres_2
  OPTIONS (user 'usr', password 'pwd');
  
IMPORT FOREIGN SCHEMA "public" limit to (table_name) FROM SERVER postgres_2 INTO public;
  
 select * from table_name