"David Lebling" <dlebling(at)ucentric(dot)com> writes:
> I investigated using 'alter table ... rename to ...' but it didn't seem to
> also rename the associated indexes, and before actually implementing code to
> do it I want to ask if that would actually work.
ALTER RENAME just changes the name of the given table. If you want to
rename indexes, use ALTER RENAME to rename them, too.
regards, tom lane