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