Re: Problem with capital letter in column name

I don't know the answer regarding configuring something. I just spotted
the lack of double-quotes around the field name in

LINE 2: ORDER BY idMunicipaliteExterne

and the lack of a capital letter in ERROR: column
"idmunicipaliteexterne" does not exist.

*/Patrick Headley/*
Linx Consulting, Inc.
pheadley(at)linxco-inc(dot)com
(303) 916-5522
www.linxco-inc.com
On 08/08/2016 01:01 PM, Marc-André Goderre wrote:
>
> Thanks Patrick but I know that i have to add double-quotes with
> capital lettre. This issue happens only when I use the contextual menu
> (right click on table --> view data)
>
> It automatically create the query and open the Query window with the
> result.
>
> Do i must configure someting or is it a bug in pgAdmin4?
>
> Thanks
>
> Marc
>
> *De :*pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] *De la part de* Patrick
> Headley
> *Envoyé :* 8 août 2016 14:49
> *À :* pgadmin-support(at)postgresql(dot)org
> *Objet :* Re: [pgadmin-support] 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 <mailto:pheadley(at)linxco-inc(dot)com>
> (303) 916-5522
> www.linxco-inc.com <http://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
>