dblink and insert?

From: Andrew Shved <andrewshved(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: dblink and insert?
Date: 2011-07-02 03:50:15
Message-ID: CAKEHZLfTrfFwM1o4qT4RaiKMP3g+=00CAxaqXSp0rFMhy+Z4dw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to ghave a driger from host1, database1, table1 to host2,
database2, table2. To insert the same row into table2 only if the row
matches certain conditions. I am not clear how to write dblink
function to do that.

Can someone ofer a piece of code to put inside of my trigger function
on host1, database1, table1. I tried different variations and all of
them fail. Or db link only reliably works on selects? by the way I am
using postgresql 8.3.

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2011-07-02 09:42:37 include directives in postgresql.conf
Previous Message Craig Ringer 2011-07-02 03:13:09 Re: statically compiling postgres and problem with initdb