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