kingbaseESV8外部表

外部数据封装器(fdw) = foreign data wrapper

create extension file_fdw;

create server file_server foreign data wrapper file_fdw;

vi /home/kingbase/t01.psv
id|name
1,oracle
2,mysql
3,postgresql

create foreign table foreign_t01(id int,name varchar(100))
server file_server
options(format'csv',header'true',filename'/home/kingbase/t01.csv',delimiter',',null'');

select * from public.foreign_t01;

drop foreign table foreign_t01;

create extension kingbase_fdw;

create server kingbase_server foreign data wrapper kingbase_fdw options(host'127.0.0.1',port'54321',dbname'foreign_db01');

create user mapping for public server kingbase_server options(user'system',password'111111');

create foreign table foreign_t02(id int,name varchar(100)) server kingbase_server options(schema_name 'public',table_name 'ora_t01');

select * from foreign_t02;

insert into foreign_t02 values(88,'kingbase');

alter foreign table foreign_t02 options(add updatable 'false');

insert into foreign_t02 values(88,'kingbase');
错误:  外部表 "foreign_t02" 不允许插入操作

alter foreign table foreign_t02 options(set updatable 'true');
insert into foreign_t02 values(88,'kingbase');

alter foreign table foreign_t02 drop column name;

---

“添加封面”显示的是java，很奇怪。