Re: first message: SELECT <column> FROM <t

Ok. That was the problem. Now SELECT "Senha" FROM USUARIOS is working fine.

But, At an application using ODBC connection I will need to send "Senha" too ?

Aílsom

2008/2/2, Ragnar <gnari(at)hive(dot)is>:
> 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
>
>
>

--
--
Aílsom F. Heringer
Rio de Janeiro, Brasil
ailsom(at)gmail(dot)com
ailsom(at)uol(dot)com(dot)br