Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

In response to

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group