connecting in shell scripts ??

* Alvaro Herrera <alvherre@protecne.cl> [010104 13:32]:

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

psql (actually libpq) will use:

PGUSER for username
PGPASSWORD for password
if they are in the environment.

Larry

When processing for output, you have to check for the prompt
"Password:", though. Maybe there's a better way...

--
Alvaro Herrera (<alvherre[@]protecne.cl>)

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

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>)