Re: createuser withpassword - Mailing list pgsql-admin

From Joel Burton
Subject Re: createuser withpassword
Date
Msg-id Pine.LNX.4.21.0105041731590.3834-100000@olympus.scw.org
Whole thread Raw
In response to createuser withpassword  ("Ligia Pimentel" <lmpimentel@yahoo.com>)
List 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@scw.org>
Director of Information Systems, Support Center of Washington


pgsql-admin by date:

Previous
From: "áÎÄÒÅÊ íÉËÕÌÏ×"
Date:
Subject: bugs or ? in PostgreSQL 7.1
Next
From: Peter Eisentraut
Date:
Subject: Re: createuser withpassword