Re: How do create a user with a bashscript

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do create a user with a bashscript
Date: 2008-09-23 05:29:24
Message-ID: 1222147764.3461.19.camel@laptop.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Wright, George 2008-09-24 13:14:04 query executions
Previous Message Sean Davis 2008-09-19 16:53:37 Re: Moving data from one set of tables to another?