Re: SQL-commands does not work

From: "Michael Swierczek" <mike(dot)swierczek(at)gmail(dot)com>
To: "Christo Romberg" <coromberg(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL-commands does not work
Date: 2006-06-19 18:15:30
Message-ID: 68b5b5880606191115r783c3290pe83f8585ceea796f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> When I try the command createdb mydb from psql, nothing happens.
> 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.

Forgive me for asking the obvious question, but are you ending your
commands with a semicolon? Psql doesn't try to do anything until it
gets the semicolon.

pgAdmin III will execute SQL without the semicolon present, although
it will not let you do multiple SQL commands at the same time without
seperating them by semicolons.

-Mike

>
> When using pgAdmin III though, everything works fine..
>
> Appreciate all the help I get!
>
> Regards,
> Christo
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Waldemar Biernacki 2006-06-19 20:11:43 really simple example of c-code and pqlib library
Previous Message Oisin Glynn 2006-06-19 18:14:10 Re: SQL-commands does not work