On Fri, Oct 25, 2019 at 7:35 AM Sonam Sharma <sonams1209@xxxxxxxxx> wrote: > > I have created indexes with certain set of columns. Now I want to remove one of the column and add new column. Can this done without dropping the index? If you are going to rename the column the answer is yes. If you are going to drop the column that would also invalidate and drop the index. If you are changing the data type the index should remain in place. See <https://www.postgresql.org/docs/12/sql-altertable.html> in particular paragraph about 'DROP COLUMN' and 'SET DATA TYPE'. Luca
