Re: [GENERAL] update data in different database

2004-10-27 Thread Richard Huxton
Henriksen, Jonas F wrote: Hi, is it possible to write a trigger, using pl/pgSQL, that updates tables in a different database than the one the trigger is called from? If it is, what is the syntax for calling the other database? My to databases are on the same server. Look into the dblink package in

Re: [GENERAL] update data in different database

2004-10-27 Thread Karsten Hilbert
> is it possible to write a trigger, using pl/pgSQL, that > updates tables in a different database than the one the trigger > is called from? If it is, what is the syntax for calling the > other database? My to databases are on the same server. One way I can think of is using dblink from the contri