Skip site navigation (1) Skip section navigation (2)


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 (view raw, whole thread or download thread mbox)
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

In response to

  • Re: at 2002-12-12 19:50:50 from Robert Treat

pgsql-admin by date

Next:From: mark carewDate: 2002-12-12 21:11:26
Subject: Re: migrating/backup script
Previous:From: Robert TreatDate: 2002-12-12 19:50:50
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group