in reply to DBI connection to multiple databases

Are you doing a one time transfer (so you can use pg_dump and pg_restore, for example) or are you going to continuously update one from the other (so you'd do a fetchrow_hashref coupled with an insert or update)?

--t. alex
Life is short: get busy!
  • Comment on Re: DBI connection to multiple databases

Replies are listed 'Best First'.
Re: Re: DBI connection to multiple databases
by Win (Novice) on Nov 11, 2003 at 15:39 UTC
    One time transfer. I am setting it up so that there is a table creation and then data transfer from a separate database, to populate this newly created table.

      If it's a one-time thing, just do a dump from one database and a restore in the other database. No need to get DBI or Perl, for that matter, involved.

      Good luck.

      --t. alex
      Life is short: get busy!