SG Edwards <[EMAIL PROTECTED]> asked: > I have a program that extracts variables from a list of > flatfiles and I want to insert these variables into a > PostreSQL database. > > I was planning on creating a CSV file with a line allocated > for each file which can then be inserted into the database > using the COPY command. > > Is the best way to do this?! > > How do I output my variables (accession, display_id, desc) to > CSV file?
Wouldn't it be much easier to do away with the intermediate CSV file and write to the database directly? Using DBI with the DBD::Pg driver that should be quite easy. HTH, Thomas -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
