On Tue, 26 Oct 2004, Philip Rhoades wrote:
> People,
>
> I presume it is OK to ask these questions here?
>
> I can rename a table:
>
> ALTER TABLE oldname RENAME TO newname ;
You can use ALTER TABLE <index/sequence name> RENAME TO <new name> in 7.4.
I've submitted a patch for ALTER INDEX <index name> to 8.0
<http://developer.postgresql.org/docs/postgres/sql-alterindex.html>.
No one has done ALTER SEQUENCE though.
Gavin