X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E1B2D8E03 for ; Thu, 15 Sep 2005 07:18:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81185-01 for ; Thu, 15 Sep 2005 10:18:44 +0000 (GMT) Received: from laptop.kieser.net (unknown [213.205.202.206]) by svr1.postgresql.org (Postfix) with ESMTP id 354F7D881A for ; Thu, 15 Sep 2005 07:18:42 -0300 (ADT) Received: from [127.0.0.1] (laptop.kieser2.demon.co.uk [127.0.0.1]) by laptop.kieser.net (Postfix) with ESMTP id 8A300BAEE9; Thu, 15 Sep 2005 11:18:41 +0100 (BST) Message-ID: <43294A81.8080006@kieser.net> Date: Thu, 15 Sep 2005 11:18:41 +0100 From: Bradley Kieser User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: cbuschini@carax.com Cc: pgsql-admin@postgresql.org Subject: Re: PSQL in a script References: <43292DAB.8090601@carax.com> In-Reply-To: <43292DAB.8090601@carax.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.96 required=5 tests=[DNS_FROM_RFC_ABUSE=0.374, HOT_NASTY=0.586] X-Spam-Level: X-Archive-Number: 200509/173 X-Sequence-Number: 18910 Cron needs full paths as no environment is inherited in the cron environment. Brad Cédric Buschini wrote: > Hi > > Here is my "problem" > I have a script where I got this line below : > > psql=`psql -h XXX.XXX.XXX.XXX. -U USER -D DATABASE -c 'SELECT COUNT(*) > FROM '$3''` > > this is not perform using a call with crontab, but launching the > script (./SCRIPT.SH) works... > > to check if it works, I added an echo $psql > > > Any ideas ??? > -- > > */ Cédric BUSCHINI > Phone : + 33 (0) 1 70 916 760 / * > > *Service Informatique* > > = Carax = > > * 11 bis rue D'aguesseau > 75008 PARIS > FRANCE* > "This message, including any attachments may contain confidential and > privileged material; it is intended only for the person to whom it is > addressed. Its contents do not constitute a commitment by CARAX except > where provided for in a written agreement. CARAX assumes no liability > or responsibility for the consequences arising out of a delay and/or > loss in transit of this message, or for corruption or other error(s) > arising in its transmission and for any misuse or fraudulent use which > may be made thereof. If you are not the intended recipient, please > contact us and abstain from any disclosure, use or dissemination. To > the extent that this message contains research information and/or > recommendations, these are provided on the same basis as CARAX's > published research and the recipient must have regard to all > disclosures and disclaimers contained therein." >