Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Auto Completion - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Query Auto Completion
Date
Msg-id CA+OCxoy3-5_S++io0qmnKHeh0Mb1PZ+HVymxtTQK551q12wjFQ@mail.gmail.com
Whole thread Raw
In response to Query Auto Completion  (Avin Kavish <avinkavish@gmail.com>)
List pgadmin-hackers
Tree view
Hi

On Thu, Jul 25, 2019 at 12:23 PM Avin Kavish <avinkavish@gmail.com> wrote:
Hi Hackers,

One major improvement I can think of for pgAdmin is query auto completion. In the Jetbrains IDEs, the database console does smart completion using relation and column names and even completes the join based on references.

For example, to get the query below I only had to type "s * f ma ij mo" (with enters in between)
Screenshot from 2019-07-25 15-40-35.jpg


Are you aware that there is already an auto-complete feature? When you want to auto-complete something, just hit Ctrl+Space for options which will popup in a menu.
 
I'm predominantly a front end developer and willing to take a crack at this.

Cool - we'd be happy to take improvements. For example, there was a request a short while ago to have the auto complete menu appear automatically if configured to do so (if memory serves).

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

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

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [pgAdmin4][Patch]: Fix for Feature #4334, RM #4496 and #4497
Next
From: Dave Page
Date:
Subject: Re: [pgAdmin][Patch] Highlight adjacent switch cell on focus in backgrid(IE11)