| 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: | Whole Thread | Raw Message | 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
| 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> |