Received: from mail.rdc1.az.home.com (imail@ha1.rdc1.az.home.com [24.1.240.66]) by hub.org (8.10.1/8.10.1) with ESMTP id e8U1cTp23148 for ; Fri, 29 Sep 2000 21:38:29 -0400 (EDT) Received: from home.com ([24.1.247.6]) by mail.rdc1.az.home.com (InterMail vM.4.01.03.00 201-229-121) with ESMTP id <20000930013823.PAOP10065.mail.rdc1.az.home.com@home.com> for ; Fri, 29 Sep 2000 18:38:23 -0700 Message-ID: <39D523C2.800C6D00@home.com> Date: Fri, 29 Sep 2000 16:20:34 -0700 From: Joel Mc Graw X-Mailer: Mozilla 4.73 [en] (X11; I; FreeBSD 4.1-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 CC: "'pgsql-sql@postgresql.org'" Subject: Re: invoke an external shell script from a function References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/238 Peter Eisentraut wrote: > > Chau, Artemis writes: > > > Does anyone know how to invoke an external shell script from a function when > > it is called from a sql statement? > > If it's a C function, use system("file"). Is this the only way to do this? I would also like to have a trigger call an external program. Is there a good place to go for more info on this? TIA