Gene Zhang <[EMAIL PROTECTED]> wrote: > instead of getting back an array or hash for each row of my SELECT, I > want the results in one string, so that I can print it just like the > psql shell client: > > e.g. > > " > id | name | myid | tsid | comment > -----+--------+------+------+--------- > (0 rows) > " > > is there a way to do this?
Not really. You'd have to fetch the rows as an array and print them out yourself. But remember you're using perl, the practical extraction and report language; that won't be too hard. :) Perl's formatting system may be of use; here's a result I found on google that describes that: http://www.webreference.com/programming/perl/format/ Cheers, Tyler