Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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

No one has done ALTER SEQUENCE though.


In response to


sydpug by date

Next:From: Neil ConwayDate: 2004-10-27 01:57:55
Subject: Re: alter table rename
Previous:From: Philip RhoadesDate: 2004-10-26 17:52:58
Subject: alter table rename

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group