On Thu, 13 Jun 2002, Vernon Wu wrote: > > Command: > > Insert into profile (userid, haveChildren)values('id98', 'No');
You presumably used double quotes when creating the column, so you need to use them to refer to the column from that point on: insert into profile(userid, "haveChildren") ... ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html