RE: can we write to a flat file from Postgresql procedure

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Jeff Eckermann <jeckermann(at)verio(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: RE: can we write to a flat file from Postgresql procedure
Date: 2001-07-11 17:51:20
Message-ID: Pine.BSO.4.10.10107111349280.23669-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Its done and committed to CVS, will be in 7.2 release.

Also done is DBD::PgSPI, interface to access postgres from within your
stored procedure. (www.formenos.org/PgSPI)

-alex

On Wed, 11 Jul 2001, Jeff Eckermann wrote:

> I haven't seen anything on this list to say that pl/perlu is being worked
> on. Is it?
>
> > -----Original Message-----
> > From: Alex Pilosov [SMTP:alex(at)pilosoft(dot)com]
> > Sent: Wednesday, July 11, 2001 10:03 AM
> > To: Peter Eisentraut
> > Cc: R Vijayanath; pgsql-sql(at)postgresql(dot)org
> > Subject: Re: can we write to a flat file from Postgresql procedure
> >
> > On Wed, 11 Jul 2001, Peter Eisentraut wrote:
> >
> > > R Vijayanath writes:
> > >
> > > > It would be great if you can tell me if I can write a
> > > > procedure that can write the output to the OS(Linux
> > > > OS) file.
> > >
> > > You could try out PL/sh for that.
> > >
> > > http://www.postgresql.org/~petere/plsh.html
> > Well, as long as we all keep plugging our favorite languages, in 7.2, you
> > can use pl/perlu ;)
> > -alex
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kristis Makris 2001-07-11 17:51:46 Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Previous Message Tom Lane 2001-07-11 16:40:27 Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0, 9) not found