Bruce Momjian wrote:
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.
They need to be consistent.   I had forgotten that the existing syntax contained the "=" character.  Either way would be fine, but the "user = " option would definitely be a welcome addition.   I