Hello

try

psql postgres -c "create role tom login password 'hello'"

Regards
Pavel


2007/7/3, Ashish Karalkar <ashish.karalkar@info-spectrum.com>:
> ----- 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/i...pq-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....
>
>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match