PSQL in a script
| От | Cédric Buschini |
|---|---|
| Тема | PSQL in a script |
| Дата | |
| Msg-id | 43292DAB.8090601@carax.com обсуждение исходный текст |
| Ответы |
Re: PSQL in a script
Re: PSQL in a script |
| Список | pgsql-admin |
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 ???
--
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 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." |
В списке pgsql-admin по дате отправления: