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

Re: moving data from text file to db

Thread Previous | Thread Next
From:
Jon Molin
Date:
March 6, 2002 00:36
Subject:
Re: moving data from text file to db
Message ID:
3C85D480.ECF71046@resfeber.se
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

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About