Re: initdb createuser commands

On 10/28/2016 04:31 PM, Samuel Williams wrote:
> Hello,
>
> Perhaps I'm missing something.
>
> However, it seems to me that there are several "generically" named
> commands, e.g. initdb, createuesr which come as part of postgresql. In
> my mind, these commands are sufficiently generic that they might clash
> with other commands. It's also not obvious they are part of
> postgresql.

See here:
https://www.postgresql.org/docs/9.5/static/reference-client.html
https://www.postgresql.org/docs/9.5/static/reference-server.html

>
> Wouldn't it make more sense to make them subcommand, of, say, a top
> level pga (postgres admin) command, a bit like how `mysqladmin` works?
>
> Just wondering as the naming of these commands seems overly generic
> and for a new user it's hard to know what commands are available since
> there is no common prefix (e.g. pg_<tab>) for these commands.

Other then initdb the commands(AFAIK) that do not have pg or postgres in
the name are just wrappers around the SQL commands of the same
name(roughly) eg dropdb = DROP DATABASE.

initdb is now accessible from pg_ctl:

https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html

>
> Thanks
> Samuel
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com