alter table rename

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