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@iol.ie
---------------------------------------------------------------