I don't know MySQL nor PgSQL, but the following may work:

$dbh->tables;
[download]

returns a list of tables

$sql = "select * from $table"
[download]

returns the data
and

$sth->{NAME}->[0];
[download]

is the name of the first column. etc

rdfield