im trying to create a script for create a database, but I dont know how write the -c part:
psql -w -h ${HOST} -U ${USER} ${DATABASE} -c CREATE DATABASE ${DATABASE} WITH OWNER = ${USER} ENCODING = 'UTF8' CONNECTION LIMIT = -1 IS_TEMPLATE = False;
Thanks!
I tried:
psql -w -h ${HOST} -U ${USER} ${DATABASE} -c "CREATE DATABASE ${DATABASE} WITH OWNER = ${USER} ENCODING = 'UTF8' CONNECTION LIMIT = -1 IS_TEMPLATE = False;"
psql -w -h ${HOST} -U ${USER} ${DATABASE} -c ""CREATE DATABASE ${DATABASE} WITH OWNER = ${USER} ENCODING = 'UTF8' CONNECTION LIMIT = -1 IS_TEMPLATE = False;""
psql -w -h ${HOST} -U ${USER} ${DATABASE} -c {CREATE DATABASE ${DATABASE} WITH OWNER = ${USER} ENCODING = 'UTF8' CONNECTION LIMIT = -1 IS_TEMPLATE = False;}
psql -w -h ${HOST} -U ${USER} ${DATABASE} -c (CREATE DATABASE ${DATABASE} WITH OWNER = ${USER} ENCODING = 'UTF8' CONNECTION LIMIT = -1 IS_TEMPLATE = False;)
But no one works for me….
For create a database
New contributor
Andres Lorenzo Carvia is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.