Thread: Inserting data in other db

Hi,

I want to insert data from a table in a database to a table of another
database when the data is added in the first table, thus using a trigger on
the 1st table.
So, is there some way to acces a 2nd database within functions of the 1st
database? Or do I have to write an extrenal application to do the
datatransfer?
I know the copy from db and copy to db commands, but then the data cant be
automaticly inserted in the 2nd database..... as far as I know.

Kind regards,

Kristoff

On Thu, Sep 01, 2005 at 01:09:55PM +0000, Toff wrote:
> I want to insert data from a table in a database to a table of another
> database when the data is added in the first table, thus using a trigger on
> the 1st table.
> So, is there some way to acces a 2nd database within functions of the 1st
> database? Or do I have to write an extrenal application to do the
> datatransfer?

You could use contrib/dblink or a function written in a procedural
language like PL/Perl that can access external data sources, but
beware that you won't get transactional semantics.  If you roll
back the transaction in the first database, you don't have a way
to propogate that rollback to the second database.

--
Michael Fuhr