Hello
try
psql postgres -c "create role tom login password 'hello'"
Regards
Pavel
2007/7/3, Ashish Karalkar <[EMAIL PROTECTED]>:
----- Original Message ----- >
> 2007/7/2, Ashish Karalkar <[EMAIL PROTECTED]>:
>
>
> 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" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc: <[email protected]>
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....
---------------------------(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
