dblink PostgreSql

--------------------------------------------------------------------------
--select dblink_connect('terang','dbname=terang user=bits password=506123');
select * from dblink('terang', 'select * from bp') as bp(bpid varchar,
bpgrpid varchar,
bpname varchar,
vatregdate date,
email varchar,
website varchar,
taxtype varchar,
indid varchar,
crcid varchar,
canvasid varchar,
srepid varchar,
areaid varchar,
prclvlid varchar,
anniversary date,
taxregno varchar,
vatregno varchar,
bankname varchar,
bankaccno varchar,
bankaccname varchar,
bpnote varchar,
purctopid varchar,
purcistaxed boolean,
purctaxinc boolean,
purctaxid varchar,
saletopid varchar,
saleistaxed boolean,
saletaxinc boolean,
saletaxid varchar,
collectorid varchar,
bpstatusid varchar,
active boolean,
_xt boolean) where bpid<>'CASH';



--isi ke bp

insert into bp select * from dblink('terang','select * from bp') as bp(bpid varchar,
bpgrpid varchar,
bpname varchar,
vatregdate date,
email varchar,
website varchar,
taxtype varchar,
indid varchar,
crcid varchar,
canvasid varchar,
srepid varchar,
areaid varchar,
prclvlid varchar,
anniversary date,
taxregno varchar,
vatregno varchar,
bankname varchar,
bankaccno varchar,
bankaccname varchar,
bpnote varchar,
purctopid varchar,
purcistaxed boolean,
purctaxinc boolean,
purctaxid varchar,
saletopid varchar,
saleistaxed boolean,
saletaxinc boolean,
saletaxid varchar,
collectorid varchar,
bpstatusid varchar,
active boolean,
_xt boolean) where bpid<>'CASH';