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

2004-11-06 Thread Leo Martin Orfei
ok. I gonna explain a little more my situation. I have a postgres server (Linux) and clients (Win2k+delphi application). I need create a text file with some columns from a table in the server machine, but this file must be created only when the user wants. (click button on my delphi program on t

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

2004-11-05 Thread Thomas F.O'Connell
At this point, I'm not sure I'm understanding your question. I'll try restating my solution again: I would have, for example, a Perl script that used the DBI module to extract information from a given database and then let Perl handle any relevant text/data manipulation and file creation/manipu

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

2004-11-04 Thread Thomas F.O'Connell
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 Ar

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

2004-11-04 Thread Leo Martin Orfei
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