Thread: Autocomplete in Query Tool not adding quotes to uppercase tables/columns

Autocomplete in Query Tool not adding quotes to uppercase tables/columns

From
Michał Małyska
Date:
<div dir="ltr"><span style="font-size:12.8px">pgAdmin 4.1</span><div style="font-size:12.8px">Windows 8.1</div><div
style="font-size:12.8px"><br/></div><div style="font-size:12.8px">I have a problem when using autocomplete feature in
QueryTool.</div><div style="font-size:12.8px">Autocomplete suggests correctly tables/columns/... but after selecting
suggestionthere are no quotes for names with capital letters in. It works OK with lowercase names.</div><div
style="font-size:12.8px"><br/></div><div style="font-size:12.8px">ex.</div><div style="font-size:12.8px">select * from
ADRES<br/></div><div style="font-size:12.8px">it shout be</div><div style="font-size:12.8px">select * from
"ADRES"</div></div>

Re: Autocomplete in Query Tool not adding quotes to uppercase tables/columns

From
Dave Page
Date:
On Fri, Nov 25, 2016 at 9:58 AM, Michał Małyska <mmalyska@gmail.com> wrote:
> pgAdmin 4.1
> Windows 8.1
>
> I have a problem when using autocomplete feature in Query Tool.
> Autocomplete suggests correctly tables/columns/... but after selecting
> suggestion there are no quotes for names with capital letters in. It works
> OK with lowercase names.
>
> ex.
> select * from ADRES
> it shout be
> select * from "ADRES"

Thanks, logged here for tracking: https://redmine.postgresql.org/issues/1992

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company