Skip site navigation (1) Skip section navigation (2)

Re: Storing an array to Postgresql table

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Mark J(dot) Bailey" <mjb(at)jobsoft(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Storing an array to Postgresql table
Date: 2005-06-19 05:27:26
Message-ID: 20050619052726.GA13971@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
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/

In response to

pgsql-novice by date

Next:From: Andreas KretschmerDate: 2005-06-19 07:23:54
Subject: Re: [despammed] allowing ',' (comma) in float8
Previous:From: rabtDate: 2005-06-18 17:45:42
Subject: BIG files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group