From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
---|---|
To: | Aílsom F(dot) Heringer <ailsom(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: first message: SELECT <column> FROM <table> |
Date: | 2008-02-02 17:48:27 |
Message-ID: | c2d9e70e0802020948k7bc9133fud8262291ae2d6e31@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Feb 2, 2008 12:36 PM, Aílsom F. Heringer <ailsom(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-02-02 17:51:49 | Re: first message: SELECT <column> FROM <table> |
Previous Message | Aílsom F. Heringer | 2008-02-02 17:36:42 | first message: SELECT <column> FROM <table> |