Обсуждение: PSQL in a script

Hi<br /><br /> Here is my "problem"<br /> I have a script where I got this line below :<br /><br /> psql=`psql -h
XXX.XXX.XXX.XXX.-U USER -D DATABASE -c 'SELECT COUNT(*) FROM '$3''`<br /><div class="moz-signature"><br /> this is not
performusing a call with crontab, but launching the script (./SCRIPT.SH) works...<br /><br /> to check if it works, I
addedan echo $psql<br /><br /><br /> Any ideas ???<br /> -- <br /><table align="center" border="0" cellspacing="0"
height="463"width="100%"><tr><td><center></center><tbody></tbody></td></tr><tr><td height="301"><div
align="left"><b><i><font face="Tahoma" size="3">Cédric</font> <font color="#324a7a" face="Tahoma"
size="3">BUSCHINI</font><br/> Phone : + 33 (0) 1 70 916 760 </i> <font face="Tahoma" size="3"> </font></b></div><font
face="Tahoma"size="3"> </font><p align="left"><font face="Tahoma" size="3"> <b><font face="Tahoma"
size="3">Service</font><font color="#324a7a" face="Tahoma" size="3"> Informatique</font></b></font><font face="Tahoma"
size="3"></font><p align="left"><font face="Tahoma" size="3"> <img alt="= Carax ="
src="cid:part1.06090805.09020208@carax.com"/> </font><font face="Tahoma" size="3"> </font><div align="left"><font
face="Tahoma"size="3"><b> <font face="Tahoma" size="2">11 bis rue D'aguesseau</font><br /><font color="#324a7a"
face="Tahoma"size="2">75008 PARIS</font><br /><font face="Tahoma"
size="2">FRANCE</font></b></font></div></td></tr><tr><td><divalign="justify"><font face="Tahoma" size="2">"This
message,including any attachments may contain confidential and privileged material; it is intended only for the person
towhom 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
transitof this message, or for corruption or other error(s) arising in its transmission and for any misuse or
fraudulentuse 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,
theseare provided on the same basis as CARAX's published research and the recipient must have regard to all disclosures
anddisclaimers contained therein." </font><font face="Tahoma" size="2"> </font></div></td></tr></table></div> 

Cédric Buschini mentioned :
=> 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 ???

psql=`psql -h XXX.XXX.XXX.XXX. -U USER -D DATABASE -c "SELECT COUNT(*) FROM '$3'"`

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."
>