| Lists: | pgsql-general |
|---|
| From: | Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | writing a file using procedure |
| Date: | 2005-06-02 09:36:45 |
| Message-ID: | 3214799999CED64882731155DB0AAD92024BC2DA@MLSW00103 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Can we write/read a file in postgresql procedure ?
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| 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 09:59:55 |
| Message-ID: | 200506021159.55985.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Am Donnerstag, 2. Juni 2005 11:36 schrieb Nageshwar Rao:
> Can we write/read a file in postgresql procedure ?
That depends on the language you use. PL/PerlU and PL/sh can do it, for
example, whereas plain PL/Perl or PL/pgSQL cannot.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| 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 |
| 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
| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| 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:03:31 |
| Message-ID: | 1117706611.7382.35.camel@sabrina.peacock.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Am Donnerstag, den 02.06.2005, 15:06 +0530 schrieb Nageshwar Rao:
> Can we write/read a file in postgresql procedure ?
Yes.
--
Tino Wildenhain <tino(at)wildenhain(dot)de>
| 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 |
| 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/