Re: Starting psql from Script - how to pass the password? - Mailing list pgsql-novice

From Dani Oderbolz
Subject Re: Starting psql from Script - how to pass the password?
Date
Msg-id 3EF30147.6000808@ecologic.de
Whole thread Raw
In response to Re: Starting psql from Script - how to pass the password?  (Hubert Lubaczewski <hubert.lubaczewski@eo.pl>)
List pgsql-novice
Hubert Lubaczewski wrote:

>sure,
>just:
>export PGPASSWORD="your_password"
>before calling postgresql programs.
>than it doesn't ask.
>but since it's raher dangerous, check if you can (version dependant), and use ~/.pgpass file instead.
>you can find more information in postgresql-docs/html/libpq-envars.html
>
Hey Hubert,
thats the solution I was after.
I realise that there are Security Implications,
but I can handle this here.

Thanks!




pgsql-novice by date:

Previous
From: Hubert Lubaczewski
Date:
Subject: Re: Starting psql from Script - how to pass the password?
Next
From: Harry Broomhall
Date:
Subject: Re: Commit within a PL/PGSQL procedure