update tables in remote db using trigger

From: Marc Wrubleski <mlwruble(at)sorexsoftware(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: update tables in remote db using trigger
Date: 2001-04-06 23:22:29
Message-ID: 3ACE4FB4.4E7C082A@sorexsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rod Taylor 2001-04-06 23:51:02 Re: update tables in remote db using trigger
Previous Message Tom Lane 2001-04-06 23:18:07 Re: How much log space does VACUUM need?