Thomas Swan wrote:
> Bruce Momjian wrote:
> 
> >TODO:  I have added a syntax suggested by someone on IRC:
> >
> >* Make it easier to create a database owned by someone who can't createdb,
> >  perhaps CREATE DATABASE dbname WITH USER = "user"
> >  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> >
> Perhaps  "CREATE DATABASE dbname WITH USER username" would fit a little 
> better.   I'd love to see this one get done... ;-)

Well, I had the equals sign because the documentation for other params
suggests it:

	CREATE DATABASE name
	    [ WITH [ LOCATION = 'dbpath' ]
	           [ TEMPLATE = template ]
	           [ ENCODING = encoding ] ]

Maybe we should make the equals optional for all these options.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

• Re: Updated TODO item at 2002-01-03 09:19:29 from Thomas Swan

Responses

• Re: Updated TODO item at 2002-01-03 18:17:39 from Thomas Swan
• Re: Updated TODO item at 2002-01-04 01:17:09 from Gavin Sherry

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2002-01-03 17:27:01
	Subject: Re: PGSQL - FAQ 4.1
Previous:	From: Bruce Momjian	Date: 2002-01-03 17:16:31
	Subject: Re: LWLock contention: I think I understand the problem

pgsql-patches by date

Next:	From: Bruce Momjian	Date: 2002-01-03 17:24:47
	Subject: Re: pg_regress.sh startup failure patch
Previous:	From: Tom Lane	Date: 2002-01-03 16:47:06
	Subject: Re: pg_regress.sh startup failure patch