From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | "Aílsom F(dot) Heringer" <ailsom(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: first message: SELECT <column> FROM <t |
Date: | 2008-02-02 17:58:53 |
Message-ID: | 47A4AF5D.8050106@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/02/2008 17:43, Aílsom F. Heringer wrote:
> 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
Can you show us the columns in your schema?
That message means exactly what it says - the column you specified
doesn't exist. One gotcha is that if you created the table using
double-quoted MiXeD-CaSe or UPPER-CASE column names, then
select senha .....
won't be the same as
select "Senha" .....
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Ragnar | 2008-02-02 17:59:04 | Re: first message: SELECT <column> FROM <t |
Previous Message | Bill Moran | 2008-02-02 17:56:19 | Re: first message: SELECT <column> FROM <t |