Re: assigning password from script

----- Original Message ----- >
> 2007/7/2, Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)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(dot)stehule(at)gmail(dot)com>
To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: <pgsql-general(at)postgresql(dot)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....