V
V
Viktor Vsk2015-05-14 19:17:23
PostgreSQL
Viktor Vsk, 2015-05-14 19:17:23

How to remove index in Postgres from JSON field?

You can create an index like this:
CREATE INDEX ON table((column->>'attribute'));
How can I delete it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Mokhov, 2015-05-14
@viktorvsk

see what name postgresql assigned to the index and delete by name

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question