Please help me out on this insert error - Mailing list pgsql-sql

From Vernon Wu
Subject Please help me out on this insert error
Date
Msg-id TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko
Whole thread Raw
Responses Re: Please help me out on this insert error
Re: Please help me out on this insert error
List pgsql-sql
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 nullsex          |
character(1)         | not nulldob          | date                  | not nullpob          | character varying(20)
|status      | character varying(20) | not nullethnicity    | character varying(20) | not nullreligion     | character
varying(20)| not nullbodytype     | character varying(20) | not nullheight       | numeric(3,0)          | not
nullweight      | numeric(2,0)          | not nulleducation    | character varying(20) |occupation   | character
varying(20)| not nullincomelow    | numeric(6,0)          | not nullincomeup     | numeric(6,0)          | not
nullhaveChildren| character varying(20) | not nullwantChildren | character varying(20) | not nulldrinking     |
charactervarying(20) |smoking      | character varying(20) | not nullnarration    | text                  |
 
Primary key: pro_pkey


What is wrong here?

Thanks.





pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Another postgres 'file not found' error
Next
From: Josh Berkus
Date:
Subject: Re: serial column vs. explicit sequence question