Re: Storing an array to Postgresql table

On Fri, Jun 17, 2005 at 09:04:32AM -0500, Mark J. Bailey wrote:
>
> so, what i am looking for essentially is an equiv to "COPY FROM" except
> the "source" is @fields and not a file.

You could use COPY FROM STDIN and pg_putline -- you wouldn't even
need to split the record:

$dbh->do("COPY foo (a, b, c, d, e) FROM STDIN WITH DELIMITER '|'");
$dbh->pg_putline("1|2|3|4|5\n");
$dbh->pg_putline("6|7|8|9|10\n");
$dbh->pg_putline("11|12|13|14|15\n");
$dbh->pg_putline("16|17|18|19|20\n");
$dbh->pg_endcopy;

See "COPY support" in the DBD::Pg documentation for more info:

http://search.cpan.org/~dbdpg/DBD-Pg-1.42/Pg.pm#COPY_support

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/