Re: [SQL] Perl and SQL - Mailing list pgsql-sql

From Igor Sysoev
Subject Re: [SQL] Perl and SQL
Date
Msg-id 199805150626.KAA24995@ns.nitek.ru
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: The Hermit Hacker
Date:
Subject: Listing the table fields ....
Next
From: Thomas Good
Date:
Subject: subscribe