Re: How do create a user with a bashscript - Mailing list pgsql-novice

On Fri, 2008-09-19 at 09:11 +0200, A B wrote:
> #!/bin/bash
> createuser  myuser
>
> but I want to supply a password on the command line, is that possible?
> The docs tells me no, but does anyone know of a workaround?

psql mydb -c "ALTER ROLE myrole WITH ENCRYPTED PASSWORD mypass"

could work, I think.
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org