Equivalent shell script of create user and schema in specificpostgres db - Mailing list pgsql-general

From Abhra Kar
Subject Equivalent shell script of create user and schema in specificpostgres db
Date
Msg-id CAFNULEeqmQxctPpUknOjdDMY8a+rEexRHauz5_1vsab9sbvZPA@mail.gmail.com
Whole thread Raw
Responses Re: Equivalent shell script of create user and schema in specificpostgres db  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List 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 by date:

Previous
From: Alexander Stoddard
Date:
Subject: Please help me understand unlogged tables
Next
From: Karsten Hilbert
Date:
Subject: Re: Equivalent shell script of create user and schema in specificpostgres db