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 . .
Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
sydpug by date
|Next:||From: Gavin Sherry||Date: 2004-10-27 01:42:27|
|Subject: Re: alter table rename|
|Previous:||From: Gavin Sherry||Date: 2004-10-04 12:52:06|
|Subject: Next meeting: October 5th at James Squire Brew House|