Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux