postgresql – EXTENSION dblink and postgres_fdw – Extention FDW

FDW is an implimentation of dblink it is more helpful, so to use it:

1-Create an extention:

CREATE EXTENSION postgres_fdw;

2-Create SERVER:

CREATE SERVER name_srv FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'hostname', 
dbname 'bd_name', port '5432');

3-Create user mapping for postgres server

CREATE USER MAPPING FOR postgres SERVER name_srv OPTIONS(user 'postgres', password 'password');

4-Create foreign table:

CREATE FOREIGN TABLE table_foreign (id INTEGER, code character varying) 
SERVER name_srv OPTIONS(schema_name 'schema', table_name 'table');

5-use this foreign table like it is in your database:

SELECT * FROM table_foreign;

if you want to reproduce, please indicate the source:
postgresql – EXTENSION dblink and postgres_fdw – Extention FDW - CodeDay