Storing an array to Postgresql table

Hello,

I am a decently proficient perl programmer of many years.  I am recently
taking up PostgreSQL in a project involving perl.  In my perl script, I
am parsing a multiline "|" delimited "report" and assembling all the
lines for a particular "record" in the report into one long "|"
delimited string that I then split:

@fields=split('\|',$l);

resulting in the array @fields containing the entire "record" in
question (one "field" per array element).

In postgresql, I have created a table whose columns are essentially in
the   exact same layout as the array elements (i.e., the table's column1
is logically the equiv to the array's element 0, i.e. $fields[0]).

so, what i am looking for essentially is an equiv to "COPY FROM" except
the "source" is @fields and not a file.  and/or some way to the
fetchrow_array method in perl DBI works (but in reverse where i have the
  array @fields and i simply want to storerow_array (though I realize
that  fetchrow_array is working with a cursor where something like a
storerow_array is more direct)).  Is there anything like "tie" for
arrays and DBI in perl like you have for the perl "DB_File" module?

i am planning on using DBI and DBD::Pg.  Should I consider PgPerl
instead?  Perl is 5.6 on a redhat fedora core 3 server.  postgresql is
8.0.3.  speed is somewhat a concern as I have (at times) several hundred
thousand "records" from the data source "report" to load and have a
limited amount of time to process on the server each night.

Thanks,

Mark

_______________________________________________________
Mark J. Bailey, CEO  Jobsoft Design & Development, Inc.
277 Wilson Pike Circle, Suite 105, Brentwood, TN  37027
EMAIL: mjb@jobsoft.com     WEB: http://www.jobsoft.com/
Medimation / CardShot(tm)    http://www.medimation.com/
Skylert(tm) -"Stay Alert, Stay Alive!"- www.skylert.com
(615)425-0932x20  FAX:(615)425-0935  CELL:(615)308-9099