Hello try psql postgres -c "create role tom login password 'hello'" Regards Pavel 2007/7/3, Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxxx>:
----- Original Message ----- > > 2007/7/2, Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxxx>: > > > 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@xxxxxxxxx> To: "Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx> Cc: <pgsql-general@xxxxxxxxxxxxxx> 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....
