How to insert into another db instance in pl/plsql... - Mailing list pgsql-general

From Rick Szeto
Subject How to insert into another db instance in pl/plsql...
Date
Msg-id se196337.071@mail.tor.csi.ca
Whole thread Raw
Responses Re: How to insert into another db instance in pl/plsql...
List 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

pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Re: [OT] GnuPG / PGP signed MD5 checksums
Next
From: Tom Lane
Date:
Subject: Re: How to Implement Versioned Rows in PostgreSQL?