createuser withpassword

От:

"Ligia Pimentel" <lmpimentel@yahoo.com>

Дата:

4 мая 2001 г. в 17:27:46

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

От:

Joel Burton <jburton@scw.org>

Дата:

4 мая 2001 г. в 18:17:56

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   
Director of Information Systems, Support Center of Washington

Re: createuser withpassword

От:

Peter Eisentraut <peter_e@gmx.net>

Дата:

4 мая 2001 г. в 19:20:50

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