Postgres Pro
Downloads
Home   >   mailing lists

Re: column does not exist Error - Mailing list pgsql-novice

From Craig Barnes
Subject Re: column does not exist Error
Date
Msg-id CAH3ft_W0duFWny6zonsZ8mFOHgA490K6_G7rx+B2ngvR+qro6A@mail.gmail.com
Whole thread Raw
In response to Re: column does not exist Error  (Ramy Abdel-Azim <ramy.abdel-azim@startdatelabs.com>)
List pgsql-novice
Tree view 
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
/\

pgsql-novice by date:

Previous
From: Ramy Abdel-Azim
Date:
Subject: Re: column does not exist Error
Next
From: piotr
Date:
Subject: Linux Mint 10 (julia): starting Postrgesql 8.4 at booting up