Ubuntu script for postgresql user creation

Question

Need help on creating a linux script that allows me to create a postgresql user with password based on the following variables:

PG_USER="username"
PG_PWD="password"

Usually I have to do it manually, but need a script based on the following code (include the flags on the script):

createuser --createdb --username postgres --no-createrole --no-superuser

Based on the above code, need a script that allows me to include the flags and also include the username and password variables.

Not sure that it is possible with createuser utility. Consider to use ~ $ PGPASSWORD=123 psql -U postgres -h localhost -c "create role $PG_USER ..." or something... — Abelisto
– Abelisto, Commented May 6, 2017 at 0:00

davejagoda · Accepted Answer · 2017-05-06 00:32:05Z

1

psql -c "CREATE USER $PG_USER WITH CREATEDB PASSWORD '$PG_PWD'"

answered May 6, 2017 at 0:32

davejagoda

2,5481 gold badge23 silver badges32 bronze badges

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

1 Answer 1