| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How do I change column details |
| Date: | 2004-03-10 01:04:25 |
| Message-ID: | 200403100104.i2A14Pu20244@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mbc | 2004-03-10 03:45:23 | unsubscribe |
| Previous Message | Simon Windsor | 2004-03-10 00:42:18 | How do I change column details |