On Thu, 4 Jan 2001, Anand Raman wrote:
> hi guys
> I wish to connect to the database thru a cron job and do some sql queries,,
> However i am having problems in connecting to the database thru the shell
> script.. I am unable to pass the password..
> I have been trying to do the following
>
> #! /bin/sh
> psql -h localhost db1 -U foo -c "select current_timestamp" < passwdfile
> where passwdfile has the passwd for the connection
How'bout something like
#!/bin/sh
USER=foo
DBNAME=db1
PASS=password_for_foo
psql -U $USER $DBNAME << EOF
$PASS
SELECT current_timestamp;
EOF
When processing for output, you have to check for the prompt
"Password:", though. Maybe there's a better way...
--
Alvaro Herrera (<alvherre[@]protecne.cl>)