Re: ALTER TABLE

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
>