On 26 Aug 2004 04:36:18 -0400, Greg Stark <gsstark@mit.edu> wrote:
>
> Bjørn T Johansen <btj@havleik.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@gmail.com>