Re: first message: SELECT FROM Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: first message: SELECT FROM
Дата
Msg-id c2d9e70e0802020948k7bc9133fud8262291ae2d6e31@mail.gmail.com
обсуждение исходный текст
Ответ на first message: SELECT FROM  ("Aílsom F. Heringer" <ailsom@gmail.com>)
Список pgsql-novice
Дерево обсуждения 
On Feb 2, 2008 12:36 PM, Aílsom F. Heringer <ailsom@gmail.com> wrote:
> Hi,
> This is my first message, and I need some help. I have just installed
> Postgresql 8.2. (Windows).
>
> At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all
> columns correctly. But when I try to get only one column, SELECT senha
> FROM USUARIOS, I get the error message:
>
> ERROR: column "senha" does not exist
> SQL state: 42703
> Character: 8
>
> What is the problem ?
>

ERROR: column "senha" does not exist

I think is pretty obvious... maybe the name has upercase letters? if
that is the case you must use the name in double-quotes (")

maybe you can show us the table definition as shown by pgAdmin 3 for
more opinions...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

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

Предыдущее
От: "Aílsom F. Heringer"
Дата:
Сообщение: first message: SELECT FROM
Следующее
От: Tom Lane
Дата:
Сообщение: Re: first message: SELECT FROM