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.