On Thu, Feb 1, 2018 at 9:42 PM, Abhra Kar wrote:
> *sudo **-u** postgres createdb ABC*
>
> *su **-c* *"**psql -d ABC**"*
>
> *if [* *$3* *==* *'x'* *]*
>
> *then*
>
> *su **-c* *"**psql -c **\"**grant all privileges on database ABC** to
> **\"**"** postgres*
>
> *su **-c* *"**psql -c **\"
*sudo **-u** postgres createdb ABC*
*su **-c* *"**psql -d ABC**"*
*if [* *$3* *==* *'x'* *]*
*then*
*su **-c* *"**psql -c **\"**grant all privileges on database ABC** to *
*\"**"** postgres*
*su **-c* *"**psql -c **\"**create schema authorization **\"**"**
postgres*
*else*
*su **
On Thu, Feb 1, 2018 at 9:09 PM, Abhra Kar wrote:
> Hi,
>
>I have to write script for psql in a xyz.sh file which should create a
> schema in a specific data.In psql prompt I achieve it like --
>
>
> postgres=# \c ABC
>
> ABC=# create schema authorization myschema
>
>
>
> In xyz.sh I exec
