Re: 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