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 34B06D8E54 for ; Thu, 15 Sep 2005 05:15:52 -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 50209-03 for ; Thu, 15 Sep 2005 08:15:48 +0000 (GMT) Received: from smtp-ft2.fr.colt.net (smtp-ft2.fr.colt.net [213.41.78.207]) by svr1.postgresql.org (Postfix) with ESMTP id 4AF0BD8BDB for ; Thu, 15 Sep 2005 05:15:41 -0300 (ADT) Received: from [192.168.10.52] (www.carax.com [62.23.146.21]) by smtp-ft2.fr.colt.net (8.13.4/8.13.4/Debian-3) with ESMTP id j8F8Fdpb013911 for ; Thu, 15 Sep 2005 10:15:39 +0200 Message-ID: <43292DAB.8090601@carax.com> Date: Thu, 15 Sep 2005 10:15:39 +0200 From: =?ISO-8859-1?Q?C=E9dric_Buschini?= Reply-To: cbuschini@carax.com Organization: CARAX User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041217 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: PSQL in a script Content-Type: multipart/related; boundary="------------050103080600060107050505" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.187 required=5 tests=[AWL=-0.931, HOT_NASTY=0.586, HTML_50_60=0.095, HTML_MESSAGE=0.001, HTML_TAG_EXIST_TBODY=0.233, HTML_TITLE_EMPTY=0.045, MIME_HTML_ONLY=1.158] X-Spam-Level: * X-Archive-Number: 200509/170 X-Sequence-Number: 18907 This is a multi-part message in MIME format. --------------050103080600060107050505 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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."
--------------050103080600060107050505 Content-Type: image/jpeg; name="logo-carax.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="logo-carax.jpg" /9j/4AAQSkZJRgABAgIAyADIAAD/wAARCACCAIIDASIAAhEBAxEB/9sAhAAFAwMEAwMFBAQE BQUFBgcNCAcHBwcQCwwJDRMQFBMSEBISFRceGRUWHBYSEhojGhwfICEiIRQZJSckICceISEg AQUFBQcGBw8ICA8gFRIVFSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICD/xAGiAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgsQAAIBAwMCBAMF BQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYn KCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SV lpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz 9PX29/j5+gEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoLEQACAQIEBAMEBwUEBAABAncA AQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqi o6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/ 2gAMAwEAAhEDEQA/APsuiiigAooooAKKKKACiiigAooooAOlFZ2v3T21nGkTFZZp44kx7sM/ oDUWoa/FpC6pdXIZrbT7T7TIEXLYAZmA9ThRigDWoqO1uYb21iubdw8MqB42HRlIyD+VSUAF FFFABRRRQAUUUUAFeP8Aiu2+P1pfXtxol/4curLzWNtAkYWTZn5Qd4Azj/ar2Cirpz5Heyfq TKPMrXPj3WP2lfi34e1GbTdVkt7O7hbbJFNYKrL/APW960/APx4+LHxD8SQ6Bp2taHbXUyM0 bXVsqK20ZwMAknHbHavavjb8FtP+K2iboxHba3aofsd0Rwe/lv6qf0PI7g/GGoafq3g7X5LS 6jn0/U7CbkZ2vE6nIII/Agj2Ir2MN7CvGyik/Q4avtKb30Pun4dWPjuytboeONU0m/mZlNv9 hiKbBg5DEgZ7Y49efTq68j/Z++O8HxJ05dG1iSOHxDbJ8w4UXaD+NR/e9V/EccD1yvKrwlCb UlY7KUlKN0FFFVdU1CPS7GS5cZ2jCqOrN2ArE0KE7DUPEaISPI0+MyOe29hwPwGTXDfFjXJr L4aar9mGdS8T3C6Tpyd2ab92v5Lvb8K60201tp8em7s3+ouXuGH8AP3j+A4ri9KCfEz4yfaL cbvDngdWtoCOUn1Blw5HqI049mOa0irLUh6vQ9Q0nTotI0u00+EkxWsCQpn0VQB/KrNFFZl7 BRRRQAUUUUAFFFFABRRRQAV5Z8evgZafE/SjqOmpHB4htU/cydBcKP8Alm5/kex9q9Toq4Tl TkpR3JlFSVmfnVFLq3hHXg6G407VLCfjqskMimvsj4E/G6z+Kmj/AGW8Mdvr9og+0wDgSjp5 iD09R2PsRWR+0N8BIviBYvr+gwJH4gt0+ZBwLxAPun/bHY/ge2PlDR9X1bwbr8OoWE01hqVj LwcbWRhwVIP4gg+4Nez+7x1PtJf19xwe9h5+R+iRIVSSQABkmuekvYtQuG1W4JGnWZ/0df8A ns/TcB+grivhr8YbT4waFtmeLTZrSMNqkIfluw8sddh/MZx9djxn40sPBmiJruqW7soYQaNp UQ/e3cx4RQvqf0HP18iVKUJcsjtU1JXRmfEXxVq2lx2+haEofxp4lzDZoORp8H8U7+ioMn3b scGu18A+CdO+HvhSy8P6YCYrZPnlb780h5eRvdjk/p2rB+FvgPUNHkvPFfiqRLjxXrIDXbKc paRD7ltH6Kvf1PPNd3UyfRDiuoUUUVBYUUUUAFFFFABRRRQAUUUUAFFFMnnitYWlmdY41GSz HAFADmIVSWIAHWvnj9oP4OxeNxeeMfDFqkdzbJ/pIHAvscZQf3gP++sY69fZb69OsQNPcu1p pCevD3PsPRf5/wAsTxV4q0jwvoL+JfFEq6fotoP9FtABvnbHyqF/iY44H9MmtqEpU5c8TOol JcrPirw34i1Hwjrlvq2my+TdWzhgGGVbB5Vh3B6EV9QfAiW3+L3iO7+I3iLUYLzWLJzb2Glx giPSoj/EAerOP4/r9B5l4y+EHjP4haRq3xQOh2+lC7l8+HRYoyJvs+OZW9XOAxGATkn0B838 CeOdY+HfiKDXNFn8uaL5ZIz9yZO6MO4P6cEcivYnGGLp3jpJHDFujLXY/QiiuX+GfxJ0j4n+ GotY0p9rjCXNsxy9vJjlT7eh7j8q6ivDlBwfLLc9GLUldBRRRUjCiiigAooooAKKKKACiisv Vntt3l3V9cIpH+qhBG78hn9aEr7C2H3+v21nJ9niDXV0ekEPJ/H0/Gsq93eZHNrR8+YnNvp8 PIB7E+v16Ust0umWEsttDb6LYRrumvbwhNo9Tk/qxrz8/EvUvFlzNpXwj0s6tcs3l3XiXUFK 2cB77SRmRh6KMdD8wrSMO5Ll2Nv4ifEPR/hzaxal4nc3mqTfLpmi2vzSSt0AC/Xqx4HucCsL wN8LvEHxA8RW/wAQPioiG4i+bSdBxmHT1PIZx3fp179egC9N8O/glpng/UX8RazeTeIvFVxz Pqt4Msp/uxL0RewxzjjpxXoNDnbRAo9wxXzL+0n+z6bRrjxn4UtMwkmTUbKJf9X3MqAdv7w7 demcfTVeYeK/B/xb8Qm/tLbxhoNlp1x5kaRpYEuImyApJzzg9RV4apKnPmi7E1YqUbNHyh8N viPrHww8SRaxpMm5ThLm2Y/JcR91P9D2Nfb/AIC8d6P8RPDkGt6NOHikG2SM/fhfHKMOxH68 EcGvnj/hivxB/wBDPpf/AH5etrwj+zP8RPAV8154c8eWVhI4xIEico47blIKn8RXoYqWHrq6 lZnNRVSm9tD6MorhfCuj/FGx1O3PiDxH4f1CwB/fLFYskrDH8JBABzjtXdV5Uo8rte52Rd+g UUUVJQUUUUAFFFHbigAqC/huJ7OWK0uBbTsuElMYfYfXb3qKe6uLSFppxZxRIMs7zFVUe5K1 Q07xbp2sXH2fTtX0S7mHWOC+WRvyFAHOT/BLSfEF3Hd+M9W1bxU8Tb47e+lVLWNvUQRhU/76 3V3NnZW2n2sdrZ28VvBEu2OKJAqoPQAcAUzdff8APO2/77P+FQDUHN8bAT2H2sR+aYPN+cJn G7b1xnjPSm22JJIv0VX/ANO9Lcfiapy65DBI0cuo6XG6nDK04BB9CM0hmpRVOCe4uohLBNZy xnoyEkH8Qakxff3rcf8AAT/jQBYoqhFevPdTWkV5YPcQBTNEpy8Yb7u4ZyM4OM9cVPtvv+et v/37P+NAFiis631D7Xcy2tvqOnyzwgGWJPmZM9MgNkdD19KlS4me5a2F5ZtKgDPGEO4D1I3c UAXKKKKACiiigAoooJwMgZx2FAHznq1x/wAJ7+2ZL4P8Zfv9A0nRheaLps/+ouZysZMjIeHY bpcZzjy/avbNZ+HfhnXbjTLm60ezE+l3cd3ZyxwqrxOhyMHGQPUCs7xx8NvDPxCuLK81rQ7v +0bBt1lqFrMbe5tj/sSIwYD26e1S6f4Q+xzwSXWreKtQW3cPFHcXoC5HTd5e3ePZ8g+lAHR6 rqlnoel3Wp6hOlvZ2kLTzyv0RFBLMfYAGvjzxf401XwV4/0D46G38SrLd3D2+v2F1o13BDbW DsFhjWR41jJCBScMQZMEZFfVHjbwtp3j/QpNE1i21T7DKwMsdvOYfMAOQrFWBIyBx7VF4u8G aT458Iv4W1y31S502VVSZfOKvMB0DMDk84P1AoA6LTr+11XT7e/sp0ntbmJZoZUOVdGAKsPY gg18yfEaztbT9s62nh8Mwa26+EpLk6eI0zdSAzf3hguccE+1e++BvC2l/Dzw7BoGjQaoNPt+ II7iVpjEv91SxJCjsO1Y9z8JvDF38QovHskGt/2/EnlR3AupAFjyT5YXO3ZyeMd6APNv2L7P Rb+08X+LNJvVtJdY1RmuPDsSFI9H2s5VNvckN94ADC4AGCB7n4r8S2Xg7w3qGvaiWFtYwNK4 QZZ8dFUd2Y4AHckCuY0v4VeEdD8f3vjnS9N1Gw1i/H+mG3lkSK49S8QO0nPOcdeepNafjPwn pPju2tLbVl1dYbS5S6jS2lkiBkRgyM23721lBAPGRQB8vx+ML/4O/GHQPiVqj699k8VJ9l8W LfaRd2sNpM7bkCNNGissa7VXGTthf+9X2MjrIgdGDKwyCOhFch8QPAHhz4n+G18PeJbbU7nT gys0aNJGZCuMFiuCeRmtXwvpen+EdCtdFsP7Te0tIxFD9p8yZ1QDAXcwJIAGBQB88ftEaN/w pHx9YfEr4ZRQW+si1kOuaPbW5aKazHBuZETAVQ20EkjJAI5Vq9s+Den+GZfCFt4k8P3n9rSa 0gu7vVplHn3kh6l8fd2kbRGOE27QOK0NC8JeH9AOqSRWd5czas+6/mvEknknG3aEYsD8gXIC fdGTgcms/wCHHw28K/Ci0ubLwtb6ra2VxIZTayPPLEjHqVVs7eg6elAHbUUDkUUAFFFFABRR RQBW1PUIdKsZbuYMyoOEQZZ2JwqqO5JIAHqa4q38Q6xeaRq1tczywX/9sW9pDhNjRJKsDELx yFDycnqFzXb3enWt+YWuYVkMEgliz/Aw6Ee9Ur3wxp1yZ547aCO8lYSidow5WUKVR8HglQeK 0hKMd0ZzjKWzMmD4h288jeTZSyQkxpFIjqR5jymJY3HVWyMkc4GScdCy28fzXdxPHHpSiK1j lkupWucLEI5pIifu8gmJiPUA8DFXNJ8Gx2wuRfSeclw0UrRCRionQ5MyknKsx2nAwBt7kknS bw9pb2lxamxh8m5t/s0yBcB4sN8h9vnb/vo0PkWwJSe5xj+Kdbu4jbLFcwKyafGrb1MwnlcP MmQADiJh2AG0nvV6f4kzw2cFwmjeb59tLOgS4znE6xRgfJ/y03Ar37Y6kdNF4f0uC5+0xWEC TeYJd4QZ3CPywc+oT5fpTLfw1pFpDFBBp1tHHEkaRqqABRG25AP91uR71XNT7E8s11Ofu/H6 w+VPcWs0EEVxdb/KlVi6QZRuCvOZGVcAj5sckVp+K9Xv9L8H6zfJGLe7t7eQ2uxg+59vyYyM ZLEDBFWJfB2gzpsfS7YrslTG3HEjBn/EkA568VavdGsdRsDY3UPm27EMULHkgggk5znIBrN8 uli0pHJ6b4r1bT5Lu2uEuNQuBqENnFbXHlxSpuiDkkxrsIIywA6AHJB4EXib4ibdCYpDcWpu ImaKeBvMZdlxHC5AAz1kJXH3gpOB0rsbfQ9OtfK8q0iUxSmZWxlvMKlC5J5LbSRk84NR2/hv SbVg0VjCCH3rkZ2nLHjPQZZjgccmrU4Xu0TyStZMxL3x9JZ2l1MmmC4NlE0t0YpyY4lELSrl 9vJK7MgDjzBjcATXQ6Xc3V3ZrNeWgtJW58rzN5A7ZOBz7dqrWvhTRbG2ltrbToIoJlVZIlXC MAoUZXp90AfQAdq06iXL9kuKfUKKKKkoKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii igAooooAKKKKAP/Z --------------050103080600060107050505--