Simon Windsor wrote: > Hi > > I have a MySQL application which I am porting to Postgres. I have been > asked to increase the size of a varchar column from 200 chars to 2000. > > Normally, in MySQL/Oracle this is done with the alter table modify > column command. > > How do I do this in Postgres? > > I have just renamed the column, created the new one, copied the data > into it and dropped the renamed column. Is the only way?
Yes, right now, that's the only way. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
