Thread: Re: [SQL] Perl and SQL

Re: [SQL] Perl and SQL

From
"Igor Sysoev"
Date:
>     Does anybody know an easy way to convert the 'INSERT INTO' command using
> perl to move data into SQL?  I know I can use Pg.pm, but this is really
> intended to do all the commands. I simply want to use my existing Perl
> scripts and all I need to do is the 'INSERT INTO' command to put new data
> into my table.  I do not have the Pg.pm set up on my site and I really do
> not need it to be if there is a simple way to use the 'INSERT INTO'
command
> with my existing perl script.

I think you can try:

$result = `psql base -c 'insert into ...'` ;

and of course your script must have rights to access database <base>.

with best regards,
Igor Sysoev