foo.pl

###### instead of

   my $statement = "SELECT name FROM public.wiki WHERE name='$name'";
    #print "$statement\n";

    next if my $arr_ref = $dbh->selectrow_arrayref($statement);

####### can do 

next if $dbh->selectrow_arrayref(<<EOQ,undef,$name);
    SELECT name
    FROM public.wiki
    WHERE name = ?
EOQ