Hi,
I have two databases which are identical in structure. One is called stats and the other is called statistics.
I have a program in php (encoded by zend hence I cannot make any changes to it) that updates the stats database tables with data. However I need to filter this data to trim it down and insert it into the statistics database tables.
I want this to happen everytime a record is added in the stats table. So i guess i will be using triggers. I am using pgadmin III.
Can anyone think of a solution to this? Your help will be appreciated!
