Postgres Pro
Downloads
Home   >   mailing lists

File output functions in PL/pgSQL? - Mailing list pgsql-general

From Andre Truter
Subject File output functions in PL/pgSQL?
Date
Msg-id 1060448794.1311.100.camel@obelix.linux.bogus
Whole thread Raw
List pgsql-general
Tree view 
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 ~

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgesql-7.3.3 lo_create/lo_open fails
Next
From: "Joshua D. Drake"
Date:
Subject: Re: FATAL: The database system is in recovery mode