Re: alter table rename

From: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
To: Philip Rhoades <phil(at)pricom(dot)com(dot)au>
Cc: sydpug(at)postgresql(dot)org
Subject: Re: alter table rename
Date: 2004-10-27 01:42:27
Message-ID: Pine.LNX.4.58.0410271140150.23432@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sydpug

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

In response to

Responses

Browse sydpug by date

  From Date Subject
Next Message Neil Conway 2004-10-27 01:57:55 Re: alter table rename
Previous Message Philip Rhoades 2004-10-26 17:52:58 alter table rename