Re: connecting in shell scripts ??

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[(at)]protecne(dot)cl>)