Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 38E0B9F9C4F for ; Wed, 29 Aug 2007 05:27:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03198-01 for ; Wed, 29 Aug 2007 05:27:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from depesz.com (depesz.com [88.198.37.40]) by postgresql.org (Postfix) with ESMTP id 28AA19F9C4B for ; Wed, 29 Aug 2007 05:27:45 -0300 (ADT) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1IQItq-0005PD-RZ; Wed, 29 Aug 2007 10:27:42 +0200 Date: Wed, 29 Aug 2007 10:27:42 +0200 From: hubert depesz lubaczewski To: qinghuamail-postgresqlfans@yahoo.com Cc: postgresql-admin Subject: Re: how to create dir using pg/plsql Message-ID: <20070829082742.GA19034@depesz.com> Reply-To: depesz@depesz.com References: <715958.65839.qm@web58103.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <715958.65839.qm@web58103.mail.re3.yahoo.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/385 X-Sequence-Number: 26716 On Wed, Aug 29, 2007 at 02:45:56PM +0800, qinghuamail-postgresqlfans@yahoo.com wrote: > just subject, > i need to create dir using pg/plsql function,,but cannt get anything after google, it's not possible. pl/pgsql is trusted language (like pl/perl and pl/tcl). trusted languages cannot use system-level functions. so no file, directory, socket access is possible. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)