File output functions in PL/pgSQL?

Started by Andre Truterover 22 years ago1 messagesgeneral
Jump to latest
#1Andre Truter
andre.truter@intekom.co.za

Hi,

Can one open, close and write to a file from a PL/pgSQL function?
I am porting an Oracle database to Postgres and the database contain
some functions that create text files to export certain data.

The functions used in Oracle is:
file_handle := UTL_FILE.FOPEN(...);
UTL_FILE.FCLOSE(file_handle);
UTL_FILE.PUT(file_handle, 'xxx');

I did not find anything in the mail archives or Google.

Any suggestions?

Thanks
--

Andre Truter Software Engineer Registered Linux user #185282
ICQ #40935899 AIM: trusoftzaf http://www.trusoft.za.net

~ A dinosaur is a salamander designed to Mil Spec ~