Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6BCiVa40484 for ; Wed, 11 Jul 2001 08:44:31 -0400 (EDT) (envelope-from janwieck@yahoo.com) Received: from jupiter.us.greatbridge.com (65.196.69.55) by smtp.mail.vip.sc5.yahoo.com with SMTP; 11 Jul 2001 12:44:26 -0000 X-Apparently-From: Received: (from wieck@localhost) by jupiter.us.greatbridge.com (8.11.2/8.11.2) id f6BCa9219642; Wed, 11 Jul 2001 08:36:09 -0400 From: Jan Wieck Message-Id: <200107111236.f6BCa9219642@jupiter.us.greatbridge.com> Subject: Re: can we write to a flat file from Postgresql procedure In-Reply-To: <20010705153407.12401.qmail@web14601.mail.yahoo.com> from R Vijayanath at "Jul 5, 2001 08:34:07 am" To: R Vijayanath Date: Wed, 11 Jul 2001 08:36:09 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/141 X-Sequence-Number: 3933 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@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com