From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Equivalent shell script of create user and schema in specific postgres db |
Date: | 2018-01-31 17:13:40 |
Message-ID: | 20180131171340.GB1998@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Blanke | 2018-01-31 17:32:35 | Re: ERROR: invalid memory alloc request size 1073741824 |
Previous Message | Abhra Kar | 2018-01-31 16:57:53 | Equivalent shell script of create user and schema in specific postgres db |