Re: the difference between psql , createdb, dropuser

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Sun, Oct 27, 2019 at 4:23 PM Setve <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?

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_")

Cheers,

Jeff