From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
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 18:12:34 |
Message-ID: | C0BC6152.D11A%sdavis2@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 6/19/06 2:09 PM, "Christo Romberg" <coromberg(at)gmail(dot)com> wrote:
> Hi!
>
> When I try the command createdb mydb from psql, nothing happens.
First, createdb is a command-line program and not a psql (or SQL) command.
The equivalent SQL command, which can be run from within psql is:
CREATE DATABASE mydb;
> I get no response whatsoever.
> My system is Windows XP Professional Edition, and my
> PostgreSQL version is 8.1.3.
>
> I can connect to a database using \c NAME OF DATABASE,
> but when trying SQL-commands, nothing happens.
You need to finish SQL statements with a semicolon. My guess is that is
your problem.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Oisin Glynn | 2006-06-19 18:14:10 | Re: SQL-commands does not work |
Previous Message | Christo Romberg | 2006-06-19 18:09:17 | SQL-commands does not work |