ALTER TABLE
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
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:
Show quoted text
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