Postgresql add dblink

Postgresql add dblink

 Open pgAdminIII Query window, execute SQL:

create extension dblink;

and create dblink extension(default no), then can see the dblink

Now, query other db data, use command:

 dblink(text,text), the first param is outside db link info, the second param is execute sql.

In other words, can firstly build the db link, and execute dblink(sql).

posted on 2015-03-25 15:52  Jerran 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/shua/p/4365921.html