Create schema with in a specific database from a script file

[Abhra Kar]

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