[SQL] Please help me out on this insert error

[Vernon Wu]

Command:

Insert into profile (userid, haveChildren)values('id98', 'No');

Error:

ERROR:  Relation 'profile' does not have attribute 'havaChildren'

Table:

                 Table "profile"
    Column    |         Type          | Modifiers
--------------+-----------------------+----------
 userid       | character varying(25) | not null
 sex          | character(1)          | not null
 dob          | date                  | not null
 pob          | character varying(20) |
 status       | character varying(20) | not null
 ethnicity    | character varying(20) | not null
 religion     | character varying(20) | not null
 bodytype     | character varying(20) | not null
 height       | numeric(3,0)          | not null
 weight       | numeric(2,0)          | not null
 education    | character varying(20) |
 occupation   | character varying(20) | not null
 incomelow    | numeric(6,0)          | not null
 incomeup     | numeric(6,0)          | not null
 haveChildren | character varying(20) | not null
 wantChildren | character varying(20) | not null
 drinking     | character varying(20) |
 smoking      | character varying(20) | not null
 narration    | text                  |
Primary key: pro_pkey


What is wrong here?

Thanks.




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])