Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: I have a tough question. Need to transfer filteref data from 1 database to another!


    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!

  2. #2
    Join Date
    Feb 2005
    Colorado Springs
    I'm not sure about a total solution to your problem. I do know that you can open only one database at a time (normally), although some front end software can access multiple databases using different users. If you want to access multiple databases, look at dbLink, a contributed PostgreSQL utility. Hope that gets you started!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts