Hyphen in postgresql username throws syntax error

[cireficc]

This one is pretty simple, but poses a problem:

Creating Postgres 'feasibility-thredded_dev' user.
ERROR:  syntax error at or near "-"
LINE 1: CREATE ROLE feasibility-thredded_dev LOGIN PASSWORD 'feasibi...
                               ^
ERROR:  syntax error at or near "-"
LINE 1: ALTER ROLE feasibility-thredded_dev CREATEDB;

I named the app feasibility-thredded, which in turn tried to create Postgres user feasibility-thredded_dev, however because of the hyphen - , there is a syntax error.

According to this PG message board topic, it simply needs to be wrapped in double quotes.

Changing L23/24 in create_database_user.sh from:

CREATE ROLE $USER LOGIN PASSWORD '$PASS';
ALTER ROLE $USER CREATEDB;

to

CREATE ROLE "$USER" LOGIN PASSWORD '$PASS';
ALTER ROLE "$USER" CREATEDB;

solves the problem.

[cireficc]

It was an easy fix so I just did it myself and opened a PR :)