pgAdmin can't create Expression Indexes

From: Michel Feinstein <michelfeinstein(at)gmail(dot)com>
To: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: pgAdmin can't create Expression Indexes
Date: 2019-05-15 02:15:33
Message-ID: CAEg4jbM_5Y+1JUjikD-om_gqS9cWLK00+au9NFT+qc1Ai39_9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2019-05-15 04:42:55 Re: pgAdmin can't create Expression Indexes
Previous Message Harrison Johnson 2019-05-14 14:34:34 help