Re: PostgreSQL pollutes the file system

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