Re: create a text file from postgres (like Oracle UTL_FILE package)

It seems like you would find it much easier to do this with a language
external to postgres (E.g., Perl) than relying on any of the built-in
languages and file I/O mechanisms.

Is there a reason you need postgres to handle this functionality?

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Nov 4, 2004, at 9:03 AM, Leo Martin Orfei wrote:

> Hi,
>
> Anybody know/have functions or package to create text
> file from postgres function?
>
> I want to execute a function to take some fields from
> a table and save it in a text file (or xml format).
> I need function like:
> createfile(filename);
> appendtofile(filename,text);
> etc.
>
> thanks