dblink 多数据库数据操作

最新推荐文章于 2024-09-14 19:55:29 发布

weixin_30247781

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量66

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/huangyong9527/archive/2012/05/30/2525077.html

版权

当前数据库为Temp；

希望从数据库qohdb查询数据，导入表groups中。

INSERT INTO groups
SELECT * FROM
dblink('host=127.0.0.1 user=sfuser password=kaisenmaru dbname=qohdb'::text, 'select * from groups'::text)
AS t1(groupid bigint, groupname group_name);

CREATE VIEW qohdbClient AS
SELECT groupid, clientid from
dblink('host=127.0.0.1 user=sfuser password=kaisenmaru dbname=qohdb'::text, 'select groupid, clientid from clients'::text)
AS t2(groupid bigint, clientid bigint);

UPDATE clients SET groupid = qohdbClient.groupid
from qohdbClient
where clients.clientid=qohdbClient.clientid;

DROP VIEW qohdbClient;

转载于:https://www.cnblogs.com/huangyong9527/archive/2012/05/30/2525077.html