On Thu, 13 Jun 2002 13:16:29 +0800, Vernon Wu <[EMAIL PROTECTED]> 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'); Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html