Re: Equivalent shell script of create user and schema in specific postgres db

2018-01-31 Thread Karsten Hilbert
On Wed, Jan 31, 2018 at 10:27:53PM +0530, Abhra Kar wrote: > 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

Equivalent shell script of create user and schema in specific postgres db

2018-01-31 Thread Abhra Kar
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 s