Adding Indexes on Expressions

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

--

<http://www.enterprisedb.com>

*Anil Sahoo*

Software Engineer

www.enterprisedb.com

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

Responses

Browse pgadmin-hackers by date

  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