Re: file I/O in plpgsql

On Friday 28 April 2006 03:47 pm, Jessica M Salmon <jmsalmon@fs.fed.us> thus
communicated:
-->
--> I'm trying to write out query results to a text file from within a
 plpgsql --> function, but having trouble. Can anyone tell me if this is
 possible? I'm --> trying to perform \o filename, then select, but it squawks
 about no --> destination for the select results. Any pointers?
--> -Meghan
-->
-->
--> ---------------------------(end of broadcast)---------------------------
--> TIP 2: Don't 'kill -9' the postmaster
-->
You cannot do that with plpgsql. You can use Perl in "trusted" mode and pass
the query results to the Perl function which can write the output to a ffile.