<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
Bruce Momjian wrote:<br>
<blockquote type="cite" cite="mid:200201031721(dot)g03HLBK16195(at)candle(dot)pha(dot)pa(dot)us">
<pre wrap="">Thomas Swan wrote:<br></pre>
<blockquote type="cite">
<pre wrap="">Bruce Momjian wrote:<br><br></pre>
<blockquote type="cite">
<pre wrap="">TODO: I have added a syntax suggested by someone on IRC:<br><br>* Make it easier 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 dbname WITH USER username" would fit a little <br>better. I'd love to see this one get done... ;-)<br></pre>
</blockquote>
<pre wrap=""><!---->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 these options.</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>
</body>
</html>