Bruce Momjian wrote:<br /><blockquote cite="mid:200201031721.g03HLBK16195@candle.pha.pa.us" type="cite"><pre
wrap="">ThomasSwan wrote:<br /></pre><blockquote type="cite"><pre wrap="">Bruce Momjian wrote:<br /><br
/></pre><blockquotetype="cite"><pre wrap="">TODO: I have added a syntax suggested by someone on IRC:<br /><br />* Make
iteasier to create a database owned by someone who can't createdb,<br /> perhaps CREATE DATABASE dbname WITH USER =
"user"<br/> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^</pre></blockquote><pre wrap="">Perhaps "CREATE DATABASE
dbnameWITH USER username" would fit a little <br />better. I'd love to see this one get done... ;-)<br
/></pre></blockquote><prewrap="">Well, I had the equals sign because the documentation for other params<br />suggests
it:<br/><br /> CREATE DATABASE name<br /> [ WITH [ LOCATION = 'dbpath' ]<br /> [ TEMPLATE =
template]<br /> [ ENCODING = encoding ] ]<br /><br />Maybe we should make the equals optional for all
theseoptions.</pre></blockquote> 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<br /><br
/><br/>
