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. # #================================================== [EMAIL PROTECTED] # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])