Re: SQL-commands does not work

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

In response to

Browse pgsql-novice by date

  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