Thread: createuser withpassword

createuser withpassword

From
"Ligia Pimentel"
Date:
I want to create a user but I want to assign a password to it from the
comand line, I don't want it to be prompted. Can it be done?

Thank you

Ligia



Re: createuser withpassword

From
Joel Burton
Date:
On Sun, 29 Apr 2001, Ligia Pimentel wrote:

> I want to create a user but I want to assign a password to it from the
> comand line, I don't want it to be prompted. Can it be done?

Without messing w/ echoing the password with appropriate newlines, it
doesn't seem possible with createuser.

Instead:
   psql -c "CREATE USER foozle WITH PASSWORD 'blobby'" template1

HTH,
--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington


Re: createuser withpassword

From
Peter Eisentraut
Date:
Ligia Pimentel writes:

> I want to create a user but I want to assign a password to it from the
> comand line, I don't want it to be prompted. Can it be done?

psql -c "create user foo with password 'bar';"

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter