Re: [GENERAL] createuser: How to specify a database to connect to - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: [GENERAL] createuser: How to specify a database to connect to
Date
Msg-id CAECtzeX-katTXnSUOoJDydB0YHDv2zOf5Zrc1L7DWwwpucca=w@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] createuser: How to specify a database to connect to  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
2017-03-13 17:10 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
Guillaume Lelarge <guillaume@lelarge.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.


--

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] createuser: How to specify a database to connect to
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] createuser: How to specify a database to connect to