Thread: Equivalent shell script of create user and schema in specificpostgres db
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
Re: Equivalent shell script of create user and schema in specificpostgres db
From
Karsten Hilbert
Date:
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 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? This rather sounds like a homework assignment. What have you tried so far ? Regards, Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346