Re: writing a file using procedure

From: Richard Huxton <dev(at)archonet(dot)com>
To: Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: writing a file using procedure
Date: 2005-06-02 10:00:56
Message-ID: 429ED8D8.3000105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Of course, you will read and write files as the user PostgreSQL runs as,
which opens up a whole world of possibilities regarding security
breaches and database destruction.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-06-02 10:03:30 Re: One Sequence for all tables or one Sequence for each
Previous Message Peter Eisentraut 2005-06-02 09:59:55 Re: writing a file using procedure