Обсуждение: How add db users from shell script with their passwords?

Dear community, help please.

I need to add some standard users to database together with their
standard passwords from a shell script. That the script would not ask
to enter passwords manually for each user. How it can be made?

How I have understood, createuser comand does not allow to make it?

In advance thanks.

--
--
С уважением, Илья Скорик
специалист
Inprint - автоматизация вашего издательства

Yours faithfully, Ilya Skorik
the expert
Inprint - automation of your publishing house

e-mail: ilya.skorik@inprint.ru
web: http://www.inprint.ru/

You can write a program in say Perl and use "create user bob with .....options ....encrypted password xxxxx valid until xxx " which is pretty much what createuser(1) does.

Cheers
Medi

Στις Tuesday 03 June 2008 11:28:44 ο/η Medi Montaseri έγραψε:
> You can write a program in say Perl and use "create user bob with
> .....options ....encrypted password xxxxx valid until xxx " which is pretty
> much what createuser(1) does.
>

why not just

#!/bin/sh
psql -c "CREATE USER foo PASSWORD 'bar'"


> Cheers
> Medi
>
> On Tue, Jun 3, 2008 at 12:54 AM, Илья Скорик <ilya.skorik@inprint.ru> wrote:
>
> > Dear community, help please.
> >
> > I need to add some standard users to database together with their
> > standard passwords from a shell script. That the script would not ask
> > to enter passwords manually for each user. How it can be made?
> >
> > How I have understood, createuser comand does not allow to make it?
> >
> > In advance thanks.
> >
> > --
> > --
> > С уважением, Илья Скорик
> > специалист
> > Inprint - автоматизация вашего издательства
> >
> > Yours faithfully, Ilya Skorik
> > the expert
> > Inprint - automation of your publishing house
> >
> > e-mail: ilya.skorik@inprint.ru
> > web: http://www.inprint.ru/
> >
> > --
> > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-admin
> >
>



--
Achilleas Mantzios