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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
