Re: postgres bash prompt error while user creation

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: postgres bash prompt error while user creation
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C26ABA9C@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на postgres bash prompt error while user creation  (Pingale.amol@gmail.com)
Список pgsql-general
>   i want to create a shell script  in that i want to create postgresql
> user and database.both this task are created properly and executed
> properly but after user and DB creation i am there on ( -bash-3.00$  )
> and i wanna come back to [root@localhost:localdomain ~]#  and my
> script is
> #!/bin/bash
> su -l postgres;
> psql -U postgres -c "CREATE USER admin27 WITH PASSWORD 'admin27'
> CREATEDB;" template1
> psql -U admin27 -c "CREATE DATABASE emcc27;" template1 \q exit;
> plzz help me to back to root from postgres bash prompt

You should probably start by reading about the basics of
shell programming. Apart from the obvious documentation
the man pages for "su" may help you to create something that
looks like a shell script.

You might consider the use of "here documents" as described
in the "bash" man page.

Yours,
Laurenz Albe

В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: nonstandard use of
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: sql