pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Perl and SQL
2+ messages / 2 participants
[nested] [flat]

* Perl and SQL
@ 1998-05-14 01:32  davez@debitnet.com
  0 siblings, 0 replies; 2+ messages in thread

From: davez@debitnet.com @ 1998-05-14 01:32 UTC (permalink / raw)
  To: 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.
	Thanks in Advance,
	Dave



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Perl and SQL
@ 1998-05-15 06:24  Igor Sysoev <igor@nitek.ru>
  0 siblings, 0 replies; 2+ messages in thread

From: Igor Sysoev @ 1998-05-15 06:24 UTC (permalink / raw)
  To: davez@debitnet.com; +Cc: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-05-15 06:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-14 01:32 Perl and SQL davez@debitnet.com
1998-05-15 06:24 Re: [SQL] Perl and SQL Igor Sysoev <igor@nitek.ru>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox