Adding Indexes on Expressions - Mailing list pgadmin-hackers

From Anil Sahoo
Subject Adding Indexes on Expressions
Date
Msg-id CAO+oWtD_RE1TgJsP7uxR1ZaBEPssHQhB6HvDLM8Yrb6Hm2n=hg@mail.gmail.com
Whole thread Raw
Responses Re: Adding Indexes on Expressions
List pgadmin-hackers
Hi Hackers,

I am currently working on the feature #2595.

Earlier using pgAdmin 4, we are able to create indexes by mentioning columns only, but Indexes on Expressions is about creating expressions of the single columns or multiple columns. This will help to retrieve data in a faster way when we use WHERE or ORDER BY clause. 

I have made a dummy UI for that and divided the Definition tab to 2 tabs such as Definition and Columns. The Columns tab will have the Columns/Expressions control and Include Columns control and all other controls that are earlier present in the Definition tab except Columns control and Include Columns control are kept as it is.

Attached the new design, please review it.

Thanks
Anil Sahoo


--

Anil Sahoo

Software Engineer

www.enterprisedb.com

Power to Postgres

             

Attachment

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Arm64 builds of pgAdmin
Next
From: Nikhil Mohite
Date:
Subject: [pgadmin-org/pgadmin4] 732bcc: Fixed an issue where the query tool is unable to e...