update data in different database

[Henriksen, Jonas F]

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.

Regards Jonas:))

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Richard Huxton]

Re: update data in different database

Henriksen, Jonas F wrote:[color=blue]
> 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.[/color]

Look into the dblink package in the contrib directory of the source
distribution (or your contrib package)

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Karsten Hilbert]

Re: update data in different database

> is it possible to write a trigger, using pl/pgSQL, that[color=blue]
> 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.[/color]
One way I can think of is using dblink from the contrib/
directory. It can be used to connect to another database from
within the one you are primarily connected to.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org