foreach $table (@tables) {
print "Export de la table $table.\n";
open OUT,">$table.CSV";
my @hcolonnes = ();
my @col_lines = @{$dbh->selectall_arrayref("select cname from col where tname='$table' order by colno")};
foreach $colonne (@col_lines) {
push @hcolonnes, @$colonne[0];
}
$colonnes = join "$sep",@hcolonnes;
my $requete = "select ".(join ",",@hcolonnes)." from $table";
print OUT "$colonnes\n";
# Requetage de la base
my $line;
my @vals = @{$dbh->selectall_arrayref($requete)};
foreach $line (@vals) {
print OUT join ("$sep",@$line);
print OUT "\n";
}
close OUT;
}