How do I create a postgresql user with fabric

Question

I want to create a database user for my setup fabric script but createuser has interactive password entering and seams not to like fabric.

Answer 1

Just use plain SQL to create a new user:

CREATE ROLE user_name WITH ENCRYPTED PASSWORD 'your password';