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

Re: SQL-commands does not work

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Christo Romberg <coromberg(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL-commands does not work
Date: 2006-06-19 20:27:28
Message-ID: 20060619202728.17201.qmail@web31810.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> When running *createdb mydb; *I get the following error message:
> 
> ERROR:  syntax error at or near "createdb" at character 1
> LINE 1: createdb mydb;
>         ^
> 
> Why can't I use createdb instead of create database?
> Same error occur when trying many other commands.

createdb is a linux/DOS shell command not a PostgreSQL SQL command.

You would find createdb in your ".../bin/" directory.

Notice:
http://www.die.net/doc/linux/man/man1/createdb.1.html

Hope this explains it a little bit better.

Regards,

Richard Broersma Jr.


In response to

pgsql-novice by date

Next:From: CoreyDate: 2006-06-19 20:40:40
Subject: get a pkey/id back from/after an insert
Previous:From: Christo RombergDate: 2006-06-19 20:19:38
Subject: Re: SQL-commands does not work

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