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 triggers:
You'll probably want to create the trigger function using PL/pgSQL:
In response to
pgsql-admin by date
|Next:||From: Gaetano Mendola||Date: 2004-02-01 01:58:52|
|Subject: release note missing|
|Previous:||From: Sally Sally||Date: 2004-01-31 18:52:06|
|Subject: Separating a single database into different disks|