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

<p>Put double-quotes around it or else it will get rolled down to lower case and won't match the actual field name.<br
/><divclass="moz-signature"><b><i>Patrick Headley</i></b><br /> Linx Consulting, Inc.<br /><a
class="moz-txt-link-abbreviated"href="mailto:pheadley@linxco-inc.com">pheadley@linxco-inc.com</a><br /> (303)
916-5522<br/><a class="moz-txt-link-abbreviated" href="http://www.linxco-inc.com">www.linxco-inc.com</a></div><div
class="moz-cite-prefix">On08/08/2016 12:43 PM, Marc-André Goderre wrote:<br /></div><blockquote
cite="mid:D8DAC91BA6256246BA3FF835F6AAA1180144133234@SI-MB02.cegep-chicoutimi.qc.ca"type="cite"><style><!--
 
/* Font Definitions */
@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Texte de bulles
Car";margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-US;}
span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;}
span.TextedebullesCar{mso-style-name:"Texte de bulles Car";mso-style-priority:99;mso-style-link:"Texte de
bulles";font-family:"Tahoma","sans-serif";}
.MsoChpDefault{mso-style-type:export-only;font-family:"Calibri","sans-serif";mso-fareast-language:EN-US;}
@page WordSection1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1{page:WordSection1;}
--></style><div class="WordSection1"><p class="MsoNormal">I work with  an  existing database containing capital letter
incolumn name.<p class="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 BY idMunicipaliteExterne </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:"Courier          New";color:#333333;background:white">********** Error **********
</span><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">SQL
state:42703 </span><p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Courier
New";color:#333333;background:white">Character:56</span><p class="MsoNormal"><span
style="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></blockquote><br/>