Home > mailing lists

pgAdmin can't create Expression Indexes - Mailing list pgadmin-support

From	Michel Feinstein
Subject	pgAdmin can't create Expression Indexes
Date	May 15, 2019 05:15:33
Msg-id	CAEg4jbM_5Y+1JUjikD-om_gqS9cWLK00+au9NFT+qc1Ai39_9w@mail.gmail.com Whole thread Raw
Responses	Re: pgAdmin can't create Expression Indexes (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
List	pgadmin-support

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

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.

From: Harrison Johnson
Date: 14 May 2019, 17:34:34
Subject: help

From: Aditya Toshniwal
Date: 15 May 2019, 07:42:55
Subject: Re: pgAdmin can't create Expression Indexes