Re: Inserting data in other db

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