Re: pgAdmin can't create Expression Indexes

I will...but just to add my 2 cents, it would be a lot better if you guys could move to Github and use their Issue system instead. 

On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi,

On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <michelfeinstein@gmail.com> wrote:

I can't find a way to create an Expression Index such as:

Yes, it's not there. You can raise a feature request here - https://redmine.postgresql.org/projects/pgadmin4/issues 

CREATE UNIQUE INDEX idx_lower_unique   ON your_table (lower(the_column));

Am I missing something or does pgAdmin really doesn't support it?

Best wishes,

Michel.

--

Thanks and Regards,

Aditya Toshniwal

Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"