Jodi Kanter <[EMAIL PROTECTED]> writes:
> Can I alter a column from character varying(128) to text without having
> to create a temp table? I am running 7.3.3.
Yeah, if you're brave enough: change the column's atttypid to 'text'
(25, I think, but check it) and atttypmod to -1 in pg_attribute.
Thi
gt; > >> > >
it's very urgnet...plz reply soon..> > >> > > Thanking
you,> > > Regds> > > C.R.Mishra> >
>> > >> > >> > >> >
>> >>
___
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
KanterSent: Tuesday, December 16,
On Tue, Dec 16, 2003 at 12:32:05PM -0500, Jodi Kanter wrote:
> Can I alter a column from character varying(128) to text without having
> to create a temp table? I am running 7.3.3.
The FAQ has a question entitled "How do you remove a column from a
table, or change its data type?":
http://www.po
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
[EMA
