From: | Aílsom F(dot) Heringer <ailsom(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: first message: SELECT <column> FROM <table> |
Date: | 2008-02-02 17:54:59 |
Message-ID: | 364e1f7e0802020954l5f5645d7hd7584b9124638b9d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
The column is defined as "Senha", but even when use "SELECT Senha FROM
Usuarios" i get the same error.
Aílsom
2008/2/2, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "=?ISO-8859-1?Q?A=EDlsom_F._Heringer?=" <ailsom(at)gmail(dot)com> writes:
> > 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
>
> Sounds like a case-sensitivity/quoting issue. I suggest carefully
> reading the rules for quoted and unquoted identifiers explained here:
>
> http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
>
> The executive summary is in the last line: "you are advised to always
> quote a particular name or never quote it". I think you probably
> created the table using a quoted identifier for "senha", except with
> some other capitalization than that.
>
> regards, tom lane
>
--
--
Aílsom F. Heringer
Rio de Janeiro, Brasil
ailsom(at)gmail(dot)com
ailsom(at)uol(dot)com(dot)br
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2008-02-02 18:23:56 | Re: first message: SELECT <column> FROM <table> |
Previous Message | Tom Lane | 2008-02-02 17:51:49 | Re: first message: SELECT <column> FROM <table> |