How to execute multiple queries as bash script

Question

I am writing one bash shell script to create connection with postgres and execute multiple queries on one connection. For that I wrote following piece of code.

#!/bin/sh

psql postgresql://$USERNAME:$PASSWORD@$HOST:$PORT -c << EOF
CREATE DATABASE $DB_NAME ;
create user $USER with encrypted password '$PASSWORD';
grant all privileges on database $DB_NAME to $USER;

EOF

But its not working and giving me following error. what's wrong with this syntax.

I guess remove `-c`. Also I suspect your file has dos line endings - remove/convert them. — KamilCuk, Feb 10 '21 at 13:57
yes , you were correct after removing -c its works fine. one more thing if I wan to store result of this query then how can do that. — keepmoving, Feb 10 '21 at 14:11
I want to see executed if its works well other failed if does not. — keepmoving, Feb 10 '21 at 14:12
https://stackoverflow.com/questions/4651437/how-do-i-set-a-variable-to-the-output-of-a-command-in-bash — KamilCuk, Feb 10 '21 at 14:18

score 0 · Answer 1 · edited Feb 10 '21 at 14:18

0

#!/bin/sh

psql postgresql://$USERNAME:$PASSWORD@$HOST:$PORT << EOF
CREATE DATABASE $DB_NAME ;
create user $USER with encrypted password '$PASSWORD';
grant all privileges on database $DB_NAME to $USER;

EOF

edited Feb 10 '21 at 14:18

answered Feb 10 '21 at 14:11

keepmoving

1,813
8
34
74

How to execute multiple queries as bash script

1 Answers1