| Lists: | sydpug |
|---|
| From: | Philip Rhoades <phil(at)pricom(dot)com(dot)au> |
|---|---|
| To: | sydpug(at)postgresql(dot)org |
| Subject: | alter table rename |
| Date: | 2004-10-26 17:52:58 |
| Message-ID: | 1098813178l.14254l.0l@prix.pricom.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | sydpug |
People,
I presume it is OK to ask these questions here?
I can rename a table:
ALTER TABLE oldname RENAME TO newname ;
but what do you do about oldname_pkey and oldname_id_seq? (I can
recreate the other indexes OK).
I can't see how to change those . .
It would have been easier if I could have just altered the width of a
column . . which is how I got into this situation, copying data between
tables etc . .
Thanks,
Phil.
--
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:(0)411-185-652
Fax: +61:(0)2-8221-9599
E-mail: phil(at)pricom(dot)com(dot)au
| 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 |
| 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: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Gavin Sherry <swm(at)alcove(dot)com(dot)au> |
| Cc: | Philip Rhoades <phil(at)pricom(dot)com(dot)au>, sydpug(at)postgresql(dot)org |
| Subject: | Re: alter table rename |
| Date: | 2004-10-27 01:57:55 |
| Message-ID: | 1098842275.1964.45.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | sydpug |
On Wed, 2004-10-27 at 11:42, Gavin Sherry wrote:
> On Tue, 26 Oct 2004, Philip Rhoades wrote:
> > I presume it is OK to ask these questions here?
It's fine, although you might get more response from a wider audience
such as pgsql-general.
> You can use ALTER TABLE <index/sequence name> RENAME TO <new name> in 7.4.
Note that this doesn't change the serial column's default value though.
BTW, in 8.0 you can change a column type's via ALTER TABLE so you don't
need this hackery.
> No one has done ALTER SEQUENCE though.
Yeah, we ought to do that -- we already have an ALTER SEQUENCE, it just
doesn't do RENAME.
-Neil