pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPSQL in a script
3+ messages / 3 participants
[nested] [flat]
* PSQL in a script
@ 2005-09-15 08:15 Cédric Buschini <cbuschini@carax.com>
2005-09-15 08:50 ` Re: PSQL in a script Stef <svb@ucs.co.za>
2005-09-15 10:18 ` Re: PSQL in a script Bradley Kieser <brad@kieser.net>
0 siblings, 2 replies; 3+ messages in thread
From: Cédric Buschini @ 2005-09-15 08:15 UTC (permalink / raw)
To: pgsql-admin
This is a multi-part message in MIME format.
--------------050103080600060107050505
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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 perform using a call with crontab, but launching the script
(./SCRIPT.SH) works...<br>
<br>
to check if it works, I added an echo $psql<br>
<br>
<br>
Any ideas ???<br>
-- <br>
<table align="center" border="0" cellspacing="0" height="463"
width="100%">
<center> </center>
<tbody>
<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></p>
<font face="Tahoma" size="3"> </font>
<p align="left"><font face="Tahoma" size="3"> <img
src="cid:part1.06090805.09020208@carax.com" alt="= Carax ="> </font></p>
<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>
<div align="justify"><font face="Tahoma" size="2">"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." </font><font face="Tahoma" size="2"> </font> </div>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
--------------050103080600060107050505
Content-Type: image/jpeg;
name="logo-carax.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.06090805.09020208@carax.com>
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--
Attachments:
logo-carax.jpg (image/jpeg, 4.2K) download
view image
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PSQL in a script
2005-09-15 08:15 PSQL in a script Cédric Buschini <cbuschini@carax.com>
@ 2005-09-15 08:50 ` Stef <svb@ucs.co.za>
1 sibling, 0 replies; 3+ messages in thread
From: Stef @ 2005-09-15 08:50 UTC (permalink / raw)
To: cbuschini@carax.com; +Cc: pgsql-admin
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'"`
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PSQL in a script
2005-09-15 08:15 PSQL in a script Cédric Buschini <cbuschini@carax.com>
@ 2005-09-15 10:18 ` Bradley Kieser <brad@kieser.net>
1 sibling, 0 replies; 3+ messages in thread
From: Bradley Kieser @ 2005-09-15 10:18 UTC (permalink / raw)
To: cbuschini@carax.com; +Cc: pgsql-admin
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."
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-09-15 10:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-15 08:15 PSQL in a script Cédric Buschini <cbuschini@carax.com>
2005-09-15 08:50 ` Stef <svb@ucs.co.za>
2005-09-15 10:18 ` Bradley Kieser <brad@kieser.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox