Re: [SQL] Perl and SQL

From: "Igor Sysoev" <igor(at)nitek(dot)ru>
To: <davez(at)debitnet(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Perl and SQL
Date: 1998-05-15 06:24:38
Message-ID: 199805150626.KAA24995@ns.nitek.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 1998-05-15 14:04:46 subscribe
Previous Message The Hermit Hacker 1998-05-15 03:28:02 Listing the table fields ....