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

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

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

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