本文主要是介绍02_Matrixdb通过数据联邦postgres_fdw访问postgresql,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
matrixdb视频教程 - 02Matrixdb通过数据联邦postgres_fdw访问postgresql
作者
shidb
日期
2021-05-08
标签
matrixdb视频教程 - 02Matrixdb通过数据联邦postgres_fdw访问postgresql
一、postgresql端
1,postgresql登陆
psql
2,建表
create table warehouse (warehouse_id int primary key, warehouse_name text, warehouse_created timestamp);
insert into warehouse values(1,‘warehouse1’,‘2021-01-01’);
insert into warehouse values(2,‘warehouse2’,‘2021-01-02’);
二、Matrixdb端
1,创建插件
create extension postgres_fdw ;
2,创建fdw_server
CREATE SERVER postgres_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host ‘sdw4’, port ‘10005’,dbname ‘postgres’);
3,创建FDW User mapping
CREATE USER MAPPING FOR shidb SERVER postgres_server OPTIONS (user ‘postgres’, password ‘123456’);
4,创建FDW Foreign Table
CREATE FOREIGN TABLE warehouse (
warehouse_id int,
warehouse_name text,
warehouse_created timestamp
)
SERVER postgres_server
OPTIONS (schema_name ‘public’,table_name ‘warehouse’);
5,查询
select * from warehouse;
6,插入
insert into warehouse values(3,‘warehouse3’,‘2020-01-03’);
7,更新
update warehouse set warehouse_name=‘warehouse21’ where warehouse_id=2;
8,删除
delete from warehouse where warehouse_id=1;
如需入群沟通交流,请扫码添加好友
这篇关于02_Matrixdb通过数据联邦postgres_fdw访问postgresql的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!