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: Pine.LNX.4.58.0410271140150.23432@linuxworld.com.au (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group