PSQL in a script

From: Cédric Buschini <cbuschini(at)carax(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: PSQL in a script
Date: 2005-09-15 08:15:39
Message-ID: 43292DAB.8090601@carax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ???

--






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




Responses

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2005-09-15 08:39:56 Reg:Database Informaton
Previous Message Tom Lane 2005-09-15 02:44:18 Re: FW: Server Time Setting