question about pgagent

Hi All,

First I will explain what I try to do:

I'd like to synchronize more or less two databases, in a third database. I mean, I want to book keep when an object has arrived in both databases. (In one database I am allowed to use trigger function but not in the other)

1) Postgres (maintenance database)

2) Database1

3) Database3
How can I set up in a cron job (pgagent), that I check if a certain value f.e. id is present in both database1 database2 and then flag this in the maintenance database?

Select_connect('myconnect', 'dbase=database1');
Select_connect('myconnect2','dbase=database2');

Using
select dblink('myconnect',....????

Thanks in advance!

Jan