On 2019-10-28 01:01, Jeff Janes wrote:
On Sun, Oct 27, 2019 at 4:23 PM Setve <setve@xxxxxxxxxxxxxx
<mailto:setve@xxxxxxxxxxxxxx>> wrote:
I can execute the create user or create db .etc... command at a
PostgreSQL interactive terminal so why are these commands
"createuser , createdb , dropdb etc.... separately and what is their
purpose?
<https://www.reddit.com/r/PostgreSQL/comments/dnyr0n/i_can_execute_the_create_user_or_create_db_etc/>
When scripting the initial set up of a system, it is easier to pass the
name to one of these programs, then to embed them into the middle of an
SQL command properly escaped and quoted. (The names of the programs
themselves are ancient history, if starting from scratch they probably
begin with "pg_")
Also, in the distant past, there was no CREATE USER command and the
createuser program inserted directly into pg_shadow.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
