stephaniecheah
01-08-2007, 02:07 AM
Hi,
I have installed PostgreSQL 7.3 with dblink.
I have 2 databases: 'database1' and 'database2'.
What i need is, whenever a new record is inserted into 'database1' , i want to insert the same record to 'database2' as well.
Anyone mind to share how this can be done as I couldn't find the proper documentation for dblink at PostgreSQL documentation.
Thanks!
I have installed PostgreSQL 7.3 with dblink.
I have 2 databases: 'database1' and 'database2'.
What i need is, whenever a new record is inserted into 'database1' , i want to insert the same record to 'database2' as well.
Anyone mind to share how this can be done as I couldn't find the proper documentation for dblink at PostgreSQL documentation.
Thanks!