use Data::Dumper;

my $sth = $dbh->prepare("SELECT * FROM jgeier.test") or die $dbh->errstr;
$sth->execute() or die $sth->errstr;

while (my $row = $sth->fetchrow_hashref) {
    print Dumper($row);
}