Postgres Pro
Downloads
Home   >   mailing lists

Re: update data in different database - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: update data in different database
Date
Msg-id 20041027140427.A647@hermes.hilbert.loc
Whole thread Raw
In response to update data in different database  ("Henriksen, Jonas F" <jonas.f.henriksen@imr.no>)
List pgsql-general
Tree view 
> 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 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

pgsql-general by date:

Previous
From: "Henriksen, Jonas F"
Date:
Subject: update data in different database
Next
From: Richard Huxton
Date:
Subject: Re: update data in different database