File output functions in PL/pgSQL?

Поиск
Список
Период
Сортировка
Искать

File output functions in PL/pgSQL?

От:
Andre 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 ~
FAQ