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 ~