Inserting data in other db - Mailing list pgsql-novice

From Toff
Subject Inserting data in other db
Date
Msg-id D4DRe.183357$gI4.10159199@phobos.telenet-ops.be
Whole thread Raw
Responses Re: Inserting data in other db  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
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



pgsql-novice by date:

Previous
From: Jan Danielsson
Date:
Subject: Last Id?
Next
From: "Jessica Broomans"
Date:
Subject: howto to do an automated backup on windows xp?