"David Lebling" <dlebling@ucentric.com> writes:
> What command would achieve this? I'm using a somewhat dusty PostgreSql
> (6.5.3).
>> ALTER TABLE an-index RENAME TO an-index-new-name;
> ERROR: TypeRename: type an-index not defined
In less-dusty Postgreses, ALTER TABLE RENAME works on indexes. I'd
recommend an update for many reasons besides this one ;-)
regards, tom lane