Equivalent shell script of create user and schema in specificpostgres db

Поиск
Список
Период
Сортировка
От Abhra Kar
Тема Equivalent shell script of create user and schema in specificpostgres db
Дата
Msg-id CAFNULEeqmQxctPpUknOjdDMY8a+rEexRHauz5_1vsab9sbvZPA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Equivalent shell script of create user and schema in specificpostgres db  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general

Create a user and schema of same name with in ‘abc’ db through linux shell –

 

Psql steps---

 

1>  [/home]# su postgres

2>  bash-4.1$ psql

3>  postgres=# \c abc  [ set database abc]

4>  abc=# create user abhra with password ‘1234’

5>  abc=# alter user abhra  with superuser

6>  abc=# create schema authorization with abhra;


 

I need to create a xyz.sh file which will do the same thing and username and password pass as argument. Like in a configuration file it will be mentioned and in xyz.sh file will be access as $1 , $2

 

What should be the equivalent shell script?

Thanks 

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

Предыдущее
От: Alexander Stoddard
Дата:
Сообщение: Please help me understand unlogged tables
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Equivalent shell script of create user and schema in specificpostgres db