Sync 2 tables in 2 databases

[SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx>]

Hi,
I have 2 postgres databases with similar structure. I want to keep some tables in sync in these 2 databases(They can be synced just once a day). Is there a way to archive this using function ?
Something like....

  Select syncTable('foo')

where syncTable is a function that compares table 'foo' in db1 with table 'foo' in db2 and make changes(update/insert/delete) to 'foo' in db1

Thanks
Sharmila


      

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general