Re: createuser withpassword

From: Joel Burton <jburton(at)scw(dot)org>
To: Ligia Pimentel <lmpimentel(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: createuser withpassword
Date: 2001-05-04 21:33:19
Message-ID: Pine.LNX.4.21.0105041731590.3834-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-04 21:46:46 Re: createuser withpassword
Previous Message Joel Burton 2001-05-04 20:13:47 Re: Queries