| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Aílsom F(dot) Heringer <ailsom(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: first message: SELECT <column> FROM <table> |
| Date: | 2008-02-02 17:51:49 |
| Message-ID: | 7961.1201974709@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"=?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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aílsom F. Heringer | 2008-02-02 17:54:59 | Re: first message: SELECT <column> FROM <table> |
| Previous Message | Jaime Casanova | 2008-02-02 17:48:27 | Re: first message: SELECT <column> FROM <table> |