Re: file I/O in plpgsql

[Terry Lee Tucker <terry(at)esc1(dot)com>]

On Friday 28 April 2006 03:47 pm, Jessica M Salmon <jmsalmon(at)fs(dot)fed(dot)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.