Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

[Bruce Momjian]

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