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

On Thu, 13 Jun 2002 13:16:29 +0800, Vernon Wu
<vernonw@gatewaytech.com> wrote:
>
>Command:
>
>Insert into profile (userid, haveChildren)values('id98', 'No');
>
>Error:
>
>ERROR:  Relation 'profile' does not have attribute 'havaChildren'
^                                cut'n'paste error here ?
 

>Table:
>                 Table "profile"
>    Column    |         Type          | Modifiers
>--------------+-----------------------+----------
> userid       | character varying(25) | not null
> [...]
> haveChildren | character varying(20) | not null

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

ServusManfred