"Gowey, Geoffrey" wrote:
> I posted this in my last message, but have not heard anything yet so I'm
> wondering if it was overlooked. I need to know how to change a column from
> being say a varchar(9) to an integer. Does anyone know how to change the
> data type?
as select col_a, col_b, varchar9col_c::int, col_d from originaltable
drop table originaltable;
alter table temptable rename to originaltable;
and then create all indexes and constraints.
In response to
pgsql-hackers by date
|Next:||From: Randal L. Schwartz||Date: 2001-09-24 15:06:59|
|Subject: Re: [HACKERS] Tupple statistics function|
|Previous:||From: Gowey, Geoffrey||Date: 2001-09-24 14:55:54|
|Subject: Re: Changing data types|