| 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: | Whole Thread | Raw Message | 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 |