[GENERAL] update tables in remote db using trigger

[Marc Wrubleski]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster