update tables in remote db using trigger - Mailing list pgsql-general

From Marc Wrubleski
Subject update tables in remote db using trigger
Date
Msg-id 3ACE4FB4.4E7C082A@sorexsoftware.com
Whole thread Raw
List pgsql-general
Hi all,

I would like to do something like the following in a trigger:

update tablename on otherdbhost set field1 = new.field1 where keyfield =
new.keyfield;

Is this a pipe dream using Postgres or is there some way to perform such
a feat?

Thanks.

Marc Wrubleski


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How much log space does VACUUM need?
Next
From: Scott Goldstein
Date:
Subject: FWD: OID