Existing table column data types cannot be altered in any stable version of postgres(7.4 or previous). I don't know if it is available in a beta release.
Can I alter a column from character varying(128) to text without having to create a temp table? I am running 7.3.3.
Thanks
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<!--[if !supportEmptyParas]--> <!--[endif]-->
<!--[if !supportEmptyParas]--> <!--[endif]-->
<!--[if !supportEmptyParas]--> <!--[endif]-->