Problem with quoting in shell script psql

Question

I'm trying to use the following in a shell (/bin/sh) script but I keep getting errors:

su postgres -c "/usr/bin/psql -c \'CREATE ROLE user WITH SUPERUSER LOGIN PASSWORD \'$password;"

It seems that something with the quoting is wrong, but I can't find what is it. I should pass the variable $password and the command as postgres user. Can someone help me?

Thanks in advance

Laurenz Albe · Accepted Answer · 2021-11-10 07:15:26Z

1

Your quotes are not even matched. You can escape double quotes within double quotes, and there is no need to escape single quotes.

su postgres -c "/usr/bin/psql -c \"CREATE ROLE username WITH SUPERUSER LOGIN PASSWORD '$password';\""

Note that user is not a valid name in SQL.

answered Nov 10, 2021 at 7:15

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem with quoting in shell script psql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related