[GENERAL] How do I change column details
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? All the best Simon -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] How do I change column details
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
