Re: assigning password from script

----- Original Message ----- >
> 2007/7/2, Ashish Karalkar <ashish.karalkar@info-spectrum.com>:
>
>
> Hello All,
>
> I want to create a user through script and dont want user to assign
> password
>  interactively, I want it to be assigned  through some file or anything
> else
>
> some this like
>
> createuser -P ***** OR createuser -P <file >
>
> Is there any way?
From: "Pavel Stehule" <pavel.stehule@gmail.com>
To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, July 02, 2007 11:24 AM
Subject: Re: [GENERAL] assigning password from script


>> Hello
> >
> >look on http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
> >
> >Pavel Stehule
Thanks Pavel Stehule for your replay,

As far as I understand the guide lines talk about providing the password
from .pgpass whene ever server requires it and not to assign the password to
the user.

"   The file .pgpass in a user's home directory or the file referenced by
PGPASSFILE can contain passwords to be used if the connection requires a
password"


Please correct me if I am wrong and if I understood correctly then Please
suggest me the way to assign password to user while its creation from a
file/ or anything else than prompting for password from terminal


With Regards
Ashish....