postgres 7.0版本,怎么样去用sql,把一个int型的字段,改成varchar型啊?在8.0版本中,可 以
ALTER TABLE "public"."itemdb_3"
ALTER COLUMN "parents_item_id" TYPE VARCHAR(128);但在7.0下面,行不通。急!!
ALTER TABLE "public"."itemdb_3"
ALTER COLUMN "parents_item_id" TYPE VARCHAR(128);但在7.0下面,行不通。急!!
update itemdb_3 set parents_item_id_n=parents_item_id;
ALTER TABLE itemdb_3 DROP COLUMN parents_item_id;
ALTER TABLE itemdb_3 RENAME COLUMN parents_item_id_n TO parents_item_id;