| 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
| 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 |