create database link STANDARD connect to OSIBANK identified by osibank using ‘(DESCRIPTION = (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.6)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=debug )) )‘;create database link CSPS connect to OSIBANK identified by osibank using ‘(DESCRIPTION = ...
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)) Using dblink in Postgres标签：本文系统来源：http://www.cnblogs.com/mignet/p/dblink_in_postgres.html