Re: Replace Old Table with New

"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