Re: Alter field type?

From: Markus Bertheau <mbertheau(at)gmail(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter field type?
Date: 2004-08-26 09:57:23
Message-ID: 5aa13ad404082602571dd52d1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 26 Aug 2004 04:36:18 -0400, Greg Stark <gsstark(at)mit(dot)edu> wrote:
>
> Bjørn T Johansen <btj(at)havleik(dot)no> writes:
>
> > Is it possible to alter field type (from varchar to text) without making a new
> > table?
>
> You can add a new column, update the table to set the new column to the old
> value. then drop the old column. Then you might want to vacuum full the table.

Does vacuum full completely remove the dropped column?

Thanks

--
Markus Bertheau <mbertheau(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Schuchardt 2004-08-26 10:03:10 Trigger question
Previous Message Bjørn T Johansen 2004-08-26 09:49:09 Re: Alter field type?