| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | vernonw(at)gatewaytech(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Please help me out on this insert error |
| Date: | 2002-06-13 22:26:29 |
| Message-ID: | 3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, 13 Jun 2002 13:16:29 +0800, Vernon Wu
<vernonw(at)gatewaytech(dot)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');
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-06-13 22:31:16 | Re: Please help me out on this insert error |
| Previous Message | Charlie Toohey | 2002-06-13 22:15:18 | Re: serial column vs. explicit sequence question |