V8R3DBLINK简单测试

建立远程连接

DB_2=# select dblink_connect('ok','dbname=TEST port=54321 user=SYSTEM password=kingbase');

 DBLINK_CONNECT

----------------

 OK

(1 row)

DB_2=#

使用link

查询：select * from dblink('ok','select * from t_table_1') as t(ID INT,T_NAME VARCHAR(32 BYTE) ,ID2 INT,ID3 INT);

建表

create table t_table_2 as select * from dblink('ok','select * from t_table_1') as t(ID INT,T_NAME VARCHAR(32 BYTE) ,ID2 INT,ID3 INT);

SELECT 10

关闭远程连接

DB_2=# select dblink_disconnect('ok');                                                      

 DBLINK_DISCONNECT

-------------------

 OK

(1 row)