| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Schmid Andreas <Andreas(dot)Schmid(at)bd(dot)so(dot)ch>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: createuser: How to specify a database to connect to |
| Date: | 2017-03-13 16:10:47 |
| Message-ID: | 11910.1489421447@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2017-03-13 16:13:11 | Re: createuser: How to specify a database to connect to |
| Previous Message | Adrian Klaver | 2017-03-13 16:05:31 | Re: createuser: How to specify a database to connect to |