in reply to Re: DBI data types
in thread DBI data types

That seems to have corrected those problems, but I seem to be having a parsing problem. I made the change to the "Use DBI" line, and I get the following when I run the script -
DBD::Pg::st execute failed: ERROR: parser: parse error at or near "al +bino" at . /dbtest.insert line 27, <CSV> line 1.
"albino" is part of a name from the file being read for the values. The file is "|" delimited, but two of the three fields have spaces between words within them. The other field is numeric. i.e. 12345|SWORDTAIL ALBINO REG|XIPHOPHORUS HELLERI (This is a fish in case you are wondering) Any ideas?????? Thanks for the help. Bradley Where ever there is confusion to be had... I'll be there.