On 26 Aug 2004 04:36:18 -0400, Greg Stark <[EMAIL PROTECTED]> wrote:
>
> Bj�rn T Johansen <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
