How to insert into another db instance in pl/plsql...

From: "Rick Szeto" <rszeto(at)csi(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to insert into another db instance in pl/plsql...
Date: 2003-01-06 16:06:11
Message-ID: se196337.071@mail.tor.csi.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I this question seems out of place on the other mailing lists, so I
posted here.

Basically, the problem is this:
I have 2 database instances. InstanceA & InstanceB
In InstanceA, I have a trigger on a table which, when activated, will
insert a row into some table in InstaceB.
The trigger is written in pl/pgsql.

How can this be done?

Any help would be greatly appreciated.
Rick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernado San Martin 2003-01-06 16:13:56 lo and vb
Previous Message wsheldah 2003-01-06 16:03:40 Re: [OT] GnuPG / PGP signed MD5 checksums