postgresql EXTENSION dblink and postgres_fdw Extention FDW
Example
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;
