Quick Links

file I/O in plpgsql

From:	Jessica M Salmon <jmsalmon(at)fs(dot)fed(dot)us>
To:	pgsql-general(at)postgresql(dot)org
Subject:	file I/O in plpgsql
Date:	2006-04-28 19:47:59
Message-ID:	OFCC42A0A8.F7AC10C4-ON8725715E.006C4422-8725715E.006CC395@fs.fed.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: file I/O in plpgsql at 2006-04-29 14:21:45 from Andreas Kretschmer
Re: file I/O in plpgsql at 2006-04-29 14:23:54 from Terry Lee Tucker
Re: file I/O in plpgsql at 2006-04-29 14:25:58 from Florian G. Pflug

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bruce Momjian	2006-04-28 19:56:19	Re: Autovacuum Logging
Previous Message	Martijn van Oosterhout	2006-04-28 19:45:39	Re: How to define + operator for strings