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: column does not exist Error
Date: 2011-11-09 21:06:39
Message-ID: CAHjAGiN4Guq3uwa+XQKhAsx51FV5hNcCOqPyftA_Y=JBHC4psg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message piotr 2011-11-09 21:08:58 Linux Mint 10 (julia): starting Postrgesql 8.4 at booting up
Previous Message Larry Rosenman 2011-11-09 16:40:30 Re: psql <database> <username> <arbitrarypassword>