@H_404_2@

@H_404_2@

@H_404_2@

@H_404_2@

主要sql语句：@H_404_2@

create server server_remote foreign data wrapper postgres_fdw options(host '127.0.0.1',port '5432',dbname 'db1');


create user mapping for wln server server_remote options(user 'user1',password '111111');


CREATE FOREIGN TABLE tb1(id int,remark text) server server_remote options (schema_name 'sch1',table_name 'tb1');
@H_404_2@

@H_404_2@

参考：@H_404_2@

postgres 官方文档@H_404_2@

https://www.postgresql.org/docs/current/static/postgres-fdw.html
@H_404_2@

@H_404_2@

PG&GP · 特性分析 · 外部数据导入接口实现分析
@H_404_2@

https://yq.aliyun.com/articles/51199?spm=5176.100239.blogcont3074.10.d6nVdg
@H_404_2@

@H_404_2@

PostgreSQL的postgres_fdw跨库使用
@H_404_2@

https://my.oschina.net/Kenyon/blog/214953 @H_404_2@