By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,716 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

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

P: n/a
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


__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.