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@xxxxxx
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
