Re: Starting psql from Script - how to pass the password?

From: Dani Oderbolz <oderbolz(at)ecologic(dot)de>
To:
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Starting psql from Script - how to pass the password?
Date: 2003-06-20 12:42:47
Message-ID: 3EF30147.6000808@ecologic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Harry Broomhall 2003-06-20 13:48:59 Re: Commit within a PL/PGSQL procedure
Previous Message Hubert Lubaczewski 2003-06-20 12:22:04 Re: Starting psql from Script - how to pass the password?