Re: [ADMIN] character type modification

[Godshall Michael]

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. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jodi Kanter Sent: Tuesday, December 16, 2003 11:32 AM To: Postgres Admin List Subject: [ADMIN] character type modification 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 [EMAIL PROTECTED] <!--[if !supportLineBreakNewLine]--> <!--[endif]--> <!--[if !supportEmptyParas]--> <!--[endif]--> <!--[if !supportEmptyParas]--> <!--[endif]--> <!--[if !supportEmptyParas]--> <!--[endif]-->