Thread: Attribute 'name' not found

  Hi....



  I don't known why postgreSQL send this error:

  test=# \d addresses
     Table "addresses"
 Column | Type | Modifiers
--------+------+-----------
 Name   | text |
 Phone  | text |
 Email  | text |

test=# select Name from addresses;
ERROR:  Attribute 'name' not found
test=#



  any ideas..???

On Fri, 16 Aug 2002, Mario Henley Becerril Geldis wrote:

>   I don't known why postgreSQL send this error:
>
>   test=# \d addresses
>      Table "addresses"
>  Column | Type | Modifiers
> --------+------+-----------
>  Name   | text |
>  Phone  | text |
>  Email  | text |
>
> test=# select Name from addresses;
> ERROR:  Attribute 'name' not found

>   any ideas..???

You probably created the table with the
column name double quoted ("Name").  If
you do so, you'll need to refer to the
column with double quotes from that point
forward (the identifier without quotes
gets case folded to lowercase - note
the error message)