架构理念:[简单][高效][可依赖] 管理理念:[价值][勇气][专注]

Using dblink in Postgres

select contractid from tcim_s_enterprice
EXCEPT
select contractid from 
dblink (
        'host=172.16.51.25 port=5432 dbname=contract user=eshop password=iTLxUQ7FUv1sBu',
        'select contractid from tcrm_s_contractmaster '
    ) AS B (
        contractid CHARACTER VARYING (100)
    )

 

posted @ 2016-04-14 11:21  文和-Mignet  阅读(276)  评论(0编辑  收藏  举报