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: 1098813178l.14254l.0l@prix.pricom.com.au (view raw or flat)
Thread:
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



Responses

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