Re: first message: SELECT FROM

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