On Thu, Feb 1, 2018 at 9:09 PM, Abhra Kar <abhra....@gmail.com> 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 executed the following script --- > > *su -c "psql -c \"\c ABC \"" postgres* > > *su -c "psql -c \"create schema authorization myschema\"" postgres* > > > > In the terminal got message “connected to ABC database”. But schema > created with in postgres database not with in ABC database. > > What should be the proper script ? > > > > Thanks and Regards, > > Abhra > > *> But schema created with in postgres database not with in ABC database. * *Just specify the database in the command line:* *EG: su -c "psql -d ABC"* -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.