Re: Replace Old Table with New

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

and there is no ALTER INDEX.

    Dave Lebling

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>