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

alter table rename

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: (view raw, whole thread or download thread mbox)
Lists: sydpug

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


Philip Rhoades

Pricom Pty Limited  (ACN 003 252 275  ABN 91 003 252 275)
GPO Box 3411
Sydney NSW	2001
Mobile:  +61:(0)411-185-652
Fax:     +61:(0)2-8221-9599
E-mail:  phil(at)pricom(dot)com(dot)au


sydpug by date

Next:From: Gavin SherryDate: 2004-10-27 01:42:27
Subject: Re: alter table rename
Previous:From: Gavin SherryDate: 2004-10-04 12:52:06
Subject: Next meeting: October 5th at James Squire Brew House

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