From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | R Vijayanath <vijayanath(at)Yahoo(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: can we write to a flat file from Postgresql procedure |
Date: | 2001-07-11 12:36:09 |
Message-ID: | 200107111236.f6BCa9219642@jupiter.us.greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
R Vijayanath wrote:
> Hi,
>
> I found your name in the Postgresql web site.
>
> It would be great if you can tell me if I can write a
> procedure that can write the output to the OS(Linux
> OS) file.
>
> Can you assist me on this if there is a way to do it.
>
> We are using Postgresql 7.1 running in Linux Redhat
> 7.1.
In version 7.1 is a procedural language PL/TclU. It's an
unrestricted (and thus untrusted) version of PL/Tcl. Meaning,
since it's possible to do any sort of OS level access from
within the backend under the postgres UNIX user-ID, only
Postgres superusers can create functions in that language.
That's the only choice other than C you have. There are no
plans yet to modify PL/pgSQL in that direction.
>
> Thanks in Advance.
You're welcome.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-11 13:51:22 | Re: cumulative sum in aggregate query. |
Previous Message | Raymond Chui | 2001-07-11 12:04:37 | Why lost all foreign key constraits after cluster? |