Home > mailing lists

Create schema with in a specific database from a script file - Mailing list pgsql-general

From	Abhra Kar
Subject	Create schema with in a specific database from a script file
Date	February 2, 2018 05:09:00
Msg-id	CAFNULEcrj_+ncsxYT6J=N75ijsYd0sO2YB=_6vXjJBBTt9D=OA@mail.gmail.com Whole thread Raw
Responses	Re: Create schema with in a specific database from a script file Create schema with in a specific database from a script file
List	pgsql-general

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

From: Geoffrey Hoffman
Date: 02 February 2018, 03:47:32
Subject: Ensure extension exists

From: Melvin Davidson
Date: 02 February 2018, 05:18:06
Subject: Re: Create schema with in a specific database from a script file