In fact, they are handled by SQL: CREATE DATABASE and DROP DATABASE. The
createdb and destroydb tools just call these SQL statements
Let's remove the "I don't want to think" utilities like
{create,destroy}{db,user} and force DBA's to actually use the *proper*
functions.
While the man pages indicate that these invoke psql, and that a postmaster
must be running, and somebody really smart could infer that that means that
there is SQL to do the action, it would be much, much better if the man
pages explicitly stated that it was merely a shortcut to using the sql.
I think only doing it the SQL way would be fine. Documentation would, of
course, have to cover it. I want, no need, to know what functionality
belongs to SQL and what belongs to PostgreSQL. I've certainly not got any
qualms about dropping into psql to do things. I like psql.
They have to connect to template1 to do the work. Currently, they don't
need to know template1 even exists, so it seems like an added burden. I
will add a mention to the createdb, destroydb man pages. createuser
does psql too.
--
Bruce Momjian | 830 Blythe Avenue
[EMAIL PROTECTED] | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup.| (610) 853-3000(h)