Re: initdb createuser commands - Mailing list pgsql-general

From Adrian Klaver
Subject Re: initdb createuser commands
Date
Msg-id 5bdef41a-c91a-177d-2b70-d5cf97551c46@aklaver.com
Whole thread Raw
In response to initdb createuser commands  (Samuel Williams <space.ship.traveller@gmail.com>)
List pgsql-general
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.klaver@aklaver.com


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: initdb createuser commands
Next
From: Samuel Williams
Date:
Subject: Re: initdb createuser commands