Re: Please help me out on this insert error

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Vernon Wu <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:12:18
Message-ID: 20020613150910.N8240-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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") ...

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-06-13 22:13:32 Re: serial column vs. explicit sequence question
Previous Message Charlie Toohey 2002-06-13 22:09:10 Re: serial column vs. explicit sequence question