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

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" <tfo@sitening.com> 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.