File output functions in PL/pgSQL?

From: Andre Truter <andre(dot)truter(at)intekom(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: File output functions in PL/pgSQL?
Date: 2003-08-09 17:06:35
Message-ID: 1060448794.1311.100.camel@obelix.linux.bogus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ~

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-08-09 17:12:35 Re: [GENERAL] FATAL: The database system is in recovery mode
Previous Message Tom Lane 2003-08-09 15:36:31 Re: Temporary table