Re: Problem with capital letter in column name

Put double-quotes around it or else it will get rolled down to lower
case and won't match the actual field name.

*/Patrick Headley/*
Linx Consulting, Inc.
pheadley(at)linxco-inc(dot)com
(303) 916-5522
www.linxco-inc.com
On 08/08/2016 12:43 PM, Marc-André Goderre wrote:
>
> I work with an existing database containing capital letter in column
> name.
>
> When i want to view data from conextual meny, it always send an error :
>
> i.e.:
>
> ERROR: column "idmunicipaliteexterne" does not exist
>
> LINE 2: ORDER BY idMunicipaliteExterne
>
> ^
>
> ********** Error **********
>
> ERROR: column "idmunicipaliteexterne" does not exist
>
> SQL state: 42703
>
> Character: 56
>
> It seems that pgadmin don't add the double quote in the ORDER BY
> clause when the column name has capital letters.
>
> PGadmin 4 beta 3
>
> Postgresql 9.1
>
> Ubuntu server 12.04
>
> Thanks
>
> Marc
>