Re: writing a file using procedure - Mailing list pgsql-general

From Michael Fuhr
Subject Re: writing a file using procedure
Date
Msg-id 20050602132738.GA93746@winnie.fuhr.org
Whole thread Raw
In response to Re: writing a file using procedure  (Richard Huxton <dev@archonet.com>)
List pgsql-general
On Thu, Jun 02, 2005 at 11:00:56AM +0100, Richard Huxton wrote:
> Nageshwar Rao wrote:
> >Can we write/read a file in postgresql procedure ?
>
> Using one of the "untrusted" languages, yes. They can only be used by an
> administrator but have access to the full capabilities of the underlying
> procedural language.

To qualify the above: only database superusers can create functions
written in an untrusted language, but any user can call such functions.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: "Gerald D. Anderson"
Date:
Subject: Re: Old problem needs solution
Next
From: Patrick.FICHE@AQSACOM.COM
Date:
Subject: Using pg_dump in a cron