Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Alter Table - Mailing list pgsql-general

From tolik@aaanet.ru (Anatoly K. Lasareff)
Subject Re: [GENERAL] Alter Table
Date
Msg-id 87vh8j3cn0.fsf@tolikus.hq.aaanet.ru
Whole thread Raw
In response to Alter Table  ("Kevin Holbrook" <kevin@templegames.com>)
List pgsql-general
Tree view 
>>>>> "KH" == Kevin Holbrook <kevin@templegames.com> writes:

 KH> Hello,
 KH> Anybody know any easy way to ALTER the column type of a column in an
 KH> existing table without dumping it?

 KH> Something akin to : ALTER TABLE tableOne CHANGE fieldOne
 KH> VARCHAR(100).

 KH> I have a limited varchar field that I want to change to TEXT.
 KH> I am using 6.4.

I think there is NO way to change the type of existing column :(

--
Anatoly K. Lasareff              Email:       tolik@icomm.ru

pgsql-general by date:

Previous
From: "Gene Selkov, Jr."
Date:
Subject: Re: [GENERAL] Yet another btree gotcha
Next
From: "Nikolay Mijaylov"
Date:
Subject: Many BLOb;s