Re: SQL-commands does not work

Поиск
Список
Период
Сортировка
От Michael Swierczek
Тема Re: SQL-commands does not work
Дата
Msg-id 68b5b5880606191115r783c3290pe83f8585ceea796f@mail.gmail.com
обсуждение исходный текст
Ответ на SQL-commands does not work  ("Christo Romberg" <coromberg@gmail.com>)
Список 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
>

В списке pgsql-novice по дате отправления:

Предыдущее
От: Oisin Glynn
Дата:
Сообщение: Re: SQL-commands does not work
Следующее
От: "Christo Romberg"
Дата:
Сообщение: Re: SQL-commands does not work