kingbase跨库访问的两种方式

方式一 创建映射

create extension kingbase_fdw;
create server oss_foreign foreign data wrapper kingbase_fdw options(hostaddr '192.168.0.240',port '55555',dbname 'oss');
create user mapping for ba server oss_foreign options(user 'oss',password '123456');
create user mapping for system server oss_foreign options(user 'oss',password '123456');
IMPORT FOREIGN SCHEMA oss  FROM SERVER oss_foreign INTO oss;
grant SELECT ON ALL tables in schema oss TO ba ;

//grant select ALL PRIVILEGES  pubm.clue_and_spvs_obj_rltn to lcss;

方式二(dblink)
//这句话只需要执行一次，会在当前会话生效，执行多次如果没释放就会报相同连接的错误

select dblink_connect('mydblink','hostaddr=ip port=54321 dbname=数据库 user=system password=123456'); 
select dblink_exec('mydblink','sql语句')

//上边这条语句只能执行ddl语句，不能执行select语句

//下边这条语句可以执行select操作，AS testTable后边的字段得是要查询的那个表的字段，要查询的字段的数量要对的上

select * from dblink('hostaddr=ip'port=54321 dbname=数据库 user=system password=123456','select * from t1') AS testTable(id int,c1 varchar,c2 varchar)