Re: writing a file using procedure

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>, pgsql-general(at)postgresql(dot)org
Subject: Re: writing a file using procedure
Date: 2005-06-02 13:27:38
Message-ID: 20050602132738.GA93746@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick.FICHE 2005-06-02 13:43:35 Using pg_dump in a cron
Previous Message Gerald D. Anderson 2005-06-02 13:13:39 Re: Old problem needs solution