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

From Richard Huxton
Subject Re: writing a file using procedure
Date
Msg-id 429ED8D8.3000105@archonet.com
Whole thread Raw
In response to writing a file using procedure  (Nageshwar Rao <NageshwarR@PLANETASIA.COM>)
Responses Re: writing a file using procedure  (Michael Fuhr <mike@fuhr.org>)
List 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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: One Sequence for all tables or one Sequence for each
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [SQL] index row size 2728 exceeds btree maximum, 2713