On 3/21/19 7:07 AM, Chris Travers wrote:
> 1. createuser/dropuser are things that I don't consider good ways of
> creating users anyway. I think we should just consider removing these
> binaries. The SQL queries are better, more functional, and can be
> rolled back as a part of a larger transaction.
Those binaries are pretty convenient to use in scripts since they handle
SQL escaping for you, but probably not convenient enough that we would
have added createuser today.
Compare
createuser "$USER"
vs
echo 'CREATE ROLE :"user" LOGIN' | psql postgres -v "user=$USER"
Andreas