Problem with capital letter in column name

From: Marc-André Goderre <magoderre(at)cgq(dot)qc(dot)ca>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Problem with capital letter in column name
Date: 2016-08-08 18:43:14
Message-ID: D8DAC91BA6256246BA3FF835F6AAA1180144133234@SI-MB02.cegep-chicoutimi.qc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Patrick Headley 2016-08-08 18:49:27 Re: Problem with capital letter in column name
Previous Message Neel Patel 2016-08-08 06:40:30 Re: unable to start pgAdmin-4 on CentOS-7