Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: zztong(at)laxmi(dot)ev(dot)net (Bruce Tong)
Cc: lynch(at)lscorp(dot)com, scrappy(at)hub(dot)org, M(dot)Boekhold(at)et(dot)tudelft(dot)nl, joden(at)lee(dot)k12(dot)nc(dot)us, pgsql-general(at)postgreSQL(dot)org, pgsql-docs(at)postgreSQL(dot)orghackers
Subject: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
Date: 1998-07-24 16:05:05
Message-ID: 199807241605.MAA18378@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
> > >> 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
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

Responses

pgsql-hackers by date

Next:From: Bruce TongDate: 1998-07-24 16:29:42
Subject: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
Previous:From: Bruce MomjianDate: 1998-07-24 16:00:16
Subject: Re: [HACKERS] cidr

pgsql-general by date

Next:From: Brett W. McCoyDate: 1998-07-24 16:06:37
Subject: Re: [GENERAL] Sufficient Primary Key?
Previous:From: Byron NikolaidisDate: 1998-07-24 16:00:31
Subject: Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group