Thread: Index

On Fri, Oct 25, 2019 at 7:35 AM Sonam Sharma <sonams1209@gmail.com> wrote:
>
> I have created indexes with certain set of columns. Now I want to remove one of the column and add new column. Can
thisdone 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

>
> I have created indexes with certain set of columns. Now I want to remove one of the column and add new column. Can
thisdone without dropping the index? 
>

If you intent is to avoid taking that table offline while the index is being built, you can do this:

1. create index concurrently on the new set of columns
2. once (1) done drop old index