On Friday 28 April 2006 03:47 pm, Jessica M Salmon <jmsalmon@xxxxxxxxx> 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.
