Re: moving data from text file to db

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);   
}


/Jon

> Thanks, Tom
> 
> --
> To unsubscribe, e-mail: beginners-unsubscribe@perl.org
> For additional commands, e-mail: beginners-help@perl.org

• moving data from text file to db by tom poe
• Re: moving data from text file to db by Jon Molin
• Re: moving data from text file to db by tom poe