Re: [SQL] Perl and SQL

Igor Sysoev <igor@nitek.ru>

From: "Igor Sysoev" <igor@nitek.ru>
To: <davez@debitnet.com>
Cc: <pgsql-sql@postgresql.org>
Date: 1998-05-15T06:24:38Z
Lists: pgsql-sql
> 	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