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

[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/manipulation.

DBI should allow the execution of arbitrary SQL against any supported 
database, and postgres is supported.

Also, I'd recommend continuing to post and not merely emailing me 
directly to keep more eyes on your problem.

-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 5, 2004, at 12:20 PM, Leo Martin Orfei wrote:
If I let the script connect to DB and create files (I
belive in this solution), how   I execute the script
from a client side? may be a function? some OS system
call?
thanks.
--- "Thomas F. O'Connell" <[EMAIL PROTECTED]> wrote:
You're thinking about it in reverse. Let the script
make calls via a
database interface. There are database interfaces to
postgres in a
variety of modern programming languages.
-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 5, 2004, at 7:24 AM, Leo Martin Orfei wrote:
ok, this appears to be a good solution...
so, how I execute a perl (or C, or bash ) script
from
a postgresql function?
if I use C (I think that write C code and use it
in
the  database is possible), I have to connect to
the
database from my C code or it's embebed and I can
use
tables directly?
thanks.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend