[PATCH] Improve autocompletion for SELECT statements - Mailing list pgadmin-hackers

From Wander Winkelhorst
Subject [PATCH] Improve autocompletion for SELECT statements
Date
Msg-id CAFv2D8so5hdLvdpM=wMs2jC3U_nEKC4ra_HevsPNq9kRhvA76g@mail.gmail.com
Whole thread Raw
Responses [PATCH] Improve autocompletion for SELECT statements
Re: [PATCH] Improve autocompletion for SELECT statements
List pgadmin-hackers
Hello,

A big part of my job is creating simple select statements with a few joins in them. Unfortunately, the existing autocomplete functionality of pgadmin was a bit too limited for my use case. A relatively simple query like: select * from person p join company c on p.company_id = c.id where p.name = 'John'  would be enough to completely throw the autocompletion off.

So I started working on a patch to improve the autocompletion a bit and the result is attached. It doesn't have all the features I would like it to have (no support for table aliases, for example) but it is already a big improvement for my use case.

Please comment if I need to change anything to get this patch into pgadmin.

This patch is against pgadmin3-1.14.0.tar.gz

Regards,
Wander Winkelhorst. 
Attachment

pgadmin-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Bug: Constraint trigger editing
Next
From: Vinicius Santos
Date:
Subject: Re: Keywords in Uppercase