Skip site navigation (1) Skip section navigation (2)

Re: column does not exist Error

From: Ramy Abdel-Azim <ramy(dot)abdel-azim(at)startdatelabs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: column does not exist Error
Date: 2011-11-09 21:10:04
Message-ID: CAHjAGiMDQywWFkbozYFzJ9+Bn3zOKMWVDRxB1iD_Cn+r-wPFMg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
it may be worth noting that i'm not naming all of the columns in the DB
table explicitly in the list of columns. I've omitted the second column
name as well as having omitted a value for the second column. I've tried
however to put the second column name into the column list and a value for
the second column. I still get the same error, though.

On Wed, Nov 9, 2011 at 4:06 PM, Ramy Abdel-Azim <
ramy(dot)abdel-azim(at)startdatelabs(dot)com> wrote:

> Hello,
>
> I'm getting a confusing error message. I'm trying to insert a row into a
> database table called "users". I'm trying to insert using the form:
>
> insert into table (column, column1, column2)
> values (value, value1, value2)
>
> however, i'm getting an error message that, relative to the query i
> provide above, would say this:
>
> ERROR:  column value1 does not exist
>
> LINE 5:   "value1","value2"
>
>                ^
>
> ....I didn't specify value1 AS a column. Why is it telling me the value
> i'm trying to insert is not a column. It shouldn't be a column. Why does it
> think it IS a column?
>
>
> Thanks,
>
> _Ramy
>

In response to

Responses

pgsql-novice by date

Next:From: Ramy Abdel-AzimDate: 2011-11-09 21:28:14
Subject: Re: column does not exist Error
Previous:From: piotrDate: 2011-11-09 21:08:58
Subject: Linux Mint 10 (julia): starting Postrgesql 8.4 at booting up

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group