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

Reply via email to