Postgres Pro
Downloads
Home   >   mailing lists

Re: character type modification - Mailing list pgsql-admin

From Godshall Michael
Subject Re: character type modification
Date
Msg-id A596FA3368757645AF862C701495CA0002A5E3A8@hor1mspmx01.gmachs.com
Whole thread Raw
In response to character type modification  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Tree view
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: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]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
jkanter@virginia.edu
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->

<!--[if !supportEmptyParas]--> <!--[endif]-->

<!--[if !supportEmptyParas]--> <!--[endif]-->

<!--[if !supportEmptyParas]--> <!--[endif]-->

pgsql-admin by date:

Previous
From: Jodi Kanter
Date:
Subject: character type modification
Next
From: Michael Fuhr
Date:
Subject: Re: character type modification