Tom Lane wrote:
>
> ALTER TABLE RENAME works on indexes (at least in recent releases).
>
> regards, tom lane
OH, stupid me, I didn't get what you meant. Treat the index name as the table
name, i.e.
alter table fubar_idx rename to fubar_idx_old;
Yes, that works, but I would never have guessed that. Is that what Postgres
should be doing?
Might not it be useful to have an "alter Object ..." which will work on
Postgres objects, like sequences, functions, etc. to make general changes.
Using alter table to rename an index seems a bit arcane.