Re: createuser: How to specify a database to connect to

2017-03-13 17:10 GMT+01:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Guillaume Lelarge <guillaume(at)lelarge(dot)info> writes:
> > It's not very hard to do. But I really wonder why it's not already done.
> I
> > fear there was a good idea, but I fail to see which one :)
>
> The core reason why we haven't complicated createuser in that particular
> direction is that createuser is only a convenience function for easy
> cases. There is not anything it could do for you that you can't do in
> psql, and there are multiple cases that it doesn't attempt to handle
> at all (some of the less-common options to CREATE USER, for instance).
> I don't have any problem with "I decided to get rid of the postgres
> database" being one of the unhandled cases.
>
>
Sure, I understand. That's fine with me. Thanks for the explanation.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com