Problem with capital letter in column name - Mailing list pgadmin-support

From Marc-André Goderre
Subject Problem with capital letter in column name
Date
Msg-id D8DAC91BA6256246BA3FF835F6AAA1180144133234@SI-MB02.cegep-chicoutimi.qc.ca
Whole thread Raw
Responses Re: Problem with capital letter in column name  (Patrick Headley <pheadley@linxco-inc.com>)
Re: Problem with capital letter in column name  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
<div class="WordSection1"><p class="MsoNormal">I work with  an  existing database containing capital letter in column
name.<pclass="MsoNormal">When i want to view data from conextual meny, it always send an error : <p
class="MsoNormal">i.e.:<pclass="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">ERROR:column "idmunicipaliteexterne" does not exist </span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier New";color:#333333;background:white">LINE 2: ORDER
BYidMunicipaliteExterne </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">                 ^</span><p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"CourierNew";color:#333333;background:white">********** Error ********** </span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier New";color:#333333;background:white">ERROR: column
"idmunicipaliteexterne"does not exist </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">SQLstate: 42703 </span><p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"CourierNew";color:#333333;background:white">Character: 56</span><p
class="MsoNormal"><spanstyle="font-size:10.5pt;font-family:"Courier New";color:#333333;background:white"> </span><p
class="MsoNormal"> <pclass="MsoNormal">It seems that pgadmin don't add the double quote in the ORDER BY clause when the
columnname has capital letters.<p class="MsoNormal"> <p class="MsoNormal">PGadmin 4 beta 3<p
class="MsoNormal">Postgresql9.1<p class="MsoNormal">Ubuntu server 12.04<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">Thanks<pclass="MsoNormal">Marc<span style="mso-fareast-language:FR-CA"></span><p
class="MsoNormal"> </div>

pgadmin-support by date:

Previous
From: Neel Patel
Date:
Subject: Re: unable to start pgAdmin-4 on CentOS-7
Next
From: Patrick Headley
Date:
Subject: Re: Problem with capital letter in column name