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

2001-07-11 Thread Alex Pilosov
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

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

2001-07-11 Thread Jeff Eckermann
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:[EMAIL PROTECTED]] > Sent: Wednesday, July 11, 2001 10:03 AM > To: Peter Eisentraut > Cc: R Vijayanath; [EMAIL PROTECTED] > Subject: Re: can we wr

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

2001-07-11 Thread Jeff Eckermann
I don't think there is any way to do this using any of the generally available tools. You could do a workaround using pl/pgsql, in the following way: * insert your data into a temp table * output the data to a file using COPY pl/pgsql allows INSERT statements, but does not allow CREA