FOREIGN DATA WRAPPER

PostgreSQL has a useful feature called Foreign Data Wrapper, which lets you create foreign tables in a PostgreSQL database that are proxies for some other data source. When you make a query against a foreign table, the Foreign Data Wrapper will query the external data source and return the results as if they were coming from a table in your database. 
  postgres=# create extension postgres_fdw;
CREATE EXTENSION : 
    postgres=# create server myserver1 foreign data wrapper postgres_fdw OPTIONS (host'192.168.1.102',dbname'kithdb',port'5432');
CREATE SERVER 
    postgres=# create user MAPPING FOR postgres SERVER myserver1 OPTIONS (user'postgres',password'post');


(DBlink)