You can't change it in place safely.
But you can use select into syntax with an explicit cast like so:
select field1::varchar(64) into newtable from oldtable
On Mon, 3 Jun 2002, Erwin Ambrosch wrote:
> Hi,
>
> I want to change the type of a column from VARCHAR(32) to VARCHAR(64) without
> dropping and recreating the table. Can one give me a hint how I can do this.
>
> Thanks Erwin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>