Re: the difference between psql , createdb, dropuser

Jeff Janes <[email protected]> Sun, 27 Oct 2019 20:01:31 -0400

Newsgroups	gmane.comp.db.postgresql.admin
Message-ID	<CAMkU=1zhMd9P2urmj_UfdgvMGU2+MKvbWCdkbPfMWvbayhctUg@mail.gmail.com>

On Sun, Oct 27, 2019 at 4:23 PM Setve <[email protected]> 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_")

Cheers,

Jeff