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