develooper Front page | perl.beginners | Postings from March 2002

Re: moving data from text file to db

Thread Previous | Thread Next
Jon Molin
March 6, 2002 00:36
Re: moving data from text file to db
Message ID:
tom poe wrote:
> Hi:  I have a script that connects to my PostgreSQL7.0.3 OK.
> Now, I also have text files that contain:
> column_name: data
> I want to open the database, open the file, read each line that has a
> column_name followed by a colon and space, then the data, and move it
> to the table in PostgreSQL.  Has anyone come across an article that looks at
> this topic specifically?

something like this maybe:

open (DATAFILE, 'somefile');
while (<DATAFILE>)
   my @values = split /: /, $_;
   my $sql = "insert into $values[0] ...
   $dbh->do ($sql);   


> Thanks, Tom
> --
> To unsubscribe, e-mail:
> For additional commands, e-mail:

Thread Previous | Thread Next Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at | Group listing | About