On Thursday 26 January 2006 19:24, Rich Shepard wrote:
> On Thu, 26 Jan 2006, Stephan Szabo wrote:
> > Did you put a semicolon at the end of the command? I get a
> > ERROR: syntax error at or near "username" at character 26
> > LINE 1: create database contacts username=sszabo
>
> Stephan,
>
> No, I did not put a semicolon there. I also received no error message,
> just the prompt. See the sample session I just posted in response to
> Michael's message.
>
> postgres=# create database testcase
> postgres-# \q
They are not the same prompt. Notice the - as opposed to the = symbol. It
was waiting for you to finish your statement (because you can use several
lines for involved SQL statements).
\q then just ended your session.
Andy