From: | Anil Sahoo <anil(dot)sahoo(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Adding Indexes on Expressions |
Date: | 2023-06-30 06:13:39 |
Message-ID: | CAO+oWtD_RE1TgJsP7uxR1ZaBEPssHQhB6HvDLM8Yrb6Hm2n=hg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
Power to Postgres
<https://www.linkedin.com/company/edbpostgres>
<https://twitter.com/edbpostgres?lang=en>
<https://www.facebook.com/EDBpostgres>
<https://www.instagram.com/EDBpostgres/>
Attachment | Content-Type | Size |
---|---|---|
Screenshot 2023-06-30 at 9.34.00 AM.png | image/png | 121.8 KB |
Screenshot 2023-06-30 at 9.35.06 AM.png | image/png | 156.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Nikhil Mohite | 2023-06-30 07:11:00 | [pgadmin-org/pgadmin4] 732bcc: Fixed an issue where the query tool is unable to e... |
Previous Message | Dave Page | 2023-06-29 18:37:01 | Re: Arm64 builds of pgAdmin |