Re: column does not exist Error

From: Craig Barnes <cjbarnes18(at)gmail(dot)com>
To: Ramy Abdel-Azim <ramy(dot)abdel-azim(at)startdatelabs(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: column does not exist Error
Date: 2011-11-09 21:37:37
Message-ID: CAH3ft_W0duFWny6zonsZ8mFOHgA490K6_G7rx+B2ngvR+qro6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Ramy,

>> ERROR: column value1 does not exist
>>
>> LINE 5: "value1","value2"
>>
>> ^
>>

When I see this message it usually means that I have used double
quotes to delimit values.

Value text strings can only be delimited by single quotes and Column
names by double quotes.

HTH
--
Craig

() ascii ribbon campaign - against html mail
/\

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message shy guy 2011-11-12 02:19:43 Windows 7 64 bit, Postgres 9 64 bit, MS C++ Express Linker error
Previous Message Ramy Abdel-Azim 2011-11-09 21:28:14 Re: column does not exist Error