Inserting data in other db

Поиск
Список
Период
Сортировка
От Toff
Тема Inserting data in other db
Дата
Msg-id D4DRe.183357$gI4.10159199@phobos.telenet-ops.be
обсуждение исходный текст
Ответы Re: Inserting data in other db  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: Jan Danielsson
Дата:
Сообщение: Last Id?
Следующее
От: "Jessica Broomans"
Дата:
Сообщение: howto to do an automated backup on windows xp?