| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | Mukund Pate <patemukund(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org, mukundpate(at)rediffmail(dot)com |
| Subject: | Re: |
| Date: | 2002-12-12 21:06:39 |
| Message-ID: | 1039727199.3562.72.camel@camel |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2002-12-12 at 14:50, Robert Treat wrote:
> On Thu, 2002-12-12 at 01:39, Mukund Pate wrote:
> > hello,
> >
> > how to modify the datatype of column in a table?
> >
> > i have created table with one coulmn datatype is varchar(200) so i
> > would like to change to text datatype
> >
>
> You will need to recreate the table.
>
> Robert Treat
Actually, I should point out that you can do an alter table add col2
text, update table set col2 = col1, update col1 set = NULL, rename col1
coldepricated, rename col2 to col1. If your in 7.3 you can drop
coldepricated too. Sorry for the weak answer before.
Robert Treat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mark carew | 2002-12-12 21:11:26 | Re: migrating/backup script |
| Previous Message | Robert Treat | 2002-12-12 19:50:50 | Re: |