On lau, 2008-02-02 at 15:43 -0200, 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 if you created the column name mixedcase with quotes, you need to access it the same way. so if the column name is really "Senha" do: SELECT "Senha" FROM USUARIOS; if that is not the problem, can you repeat this in the command-line tool psql ? gnari ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
