Re: [ADMIN] 'dblink' Help

2004-01-31 Thread Joe Conway
JinNet Picker wrote: What i need is, when ever a NEW record is inserted in 'MyDb1' , i want fire a Trigger or Rule to insert the Same Record to MyDb2 database. Anybody Got Idea how to do this? See the dblink documentation for dblink_exec(), and see the Postgres documentation for how to create tr

[ADMIN] 'dblink' Help

2004-01-29 Thread JinNet Picker
Hi, I have Two databases names 'MyDb1' and 'MyDb2' in My System. I have installed Postgres 7.4 with dblink What i need is, when ever a NEW record is inserted in 'MyDb1' , i want fire a Trigger or Rule to insert the Same Record to MyDb2 database. I am Using MAC OS 10.2 Anybody Got Idea how to d