DBI - How to pass the result from one DB into another

From: Jan Pips (jan_pips_at_op.pl)
Date: 10/24/03 

Date: Fri, 24 Oct 2003 13:40:15 +0200

I have two DBI drivers: Pg and CSV. How to pass (in other words copy) the
result from one select on Pg database into CSV database? For example:

$SQLString = "
                      select *
                      from schema.db1;
                 ";
    $sth = $dbh -> prepare($SQLString) || die "Error preparing query:
$DBI::errstr \n";
    $sth -> execute() || die "Error executing query: $DBI::errstr \n";

and I want the result of such select to be copied into CSV database.

Pips