Skip site navigation (1) Skip section navigation (2)

Re: syntax errors at "line 1" when executing every command

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: syntax errors at "line 1" when executing every command
Date: 2008-02-28 21:04:37
Message-ID: fq77l3$5rs$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-general
Steven De Vriendt wrote on 28.02.2008 21:42:
> Hi list,
> 
> I'm using the latest postgreSQL with the lastest postgis.
> When executing every command I want to use, I get the following error
> message:
> 
> postgis=# createdb;
> ERROR:  syntax error at or near "createdb"
> LINE 1: createdb;
>             ^
> 
> I can use psql to reach my database, but after that I'm finished.
> Can't use any command. I thought this was a Vista (PATH) issue
> so I turned to Windows XP, however, I encounter the exact
> same issue. What am I doing wrong ??

createdb is an OS-level command, it is not a psql command!
The equivalent SQL command is "CREATE DATABASE"

Thomas


In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-02-28 21:08:06
Subject: Re: partitioning using dblink
Previous:From: Colin WetherbeeDate: 2008-02-28 21:03:44
Subject: Re: syntax errors at "line 1" when executing every command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group