Thread

1. Changing data types

   Geoffrey J. Gowey <ggowey@rxhope.com> — 2001-09-24T14:18:34Z

   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?
   
   Geoff
   
   

2. Re: Changing data types

   Alex Pilosov <alex@pilosoft.com> — 2001-09-24T14:40:23Z

   This is not for -hackers. 
   
   And the answer is "no, you can't". Recreate the table with correct types
   and insert the old values into it.
   
   On Mon, 24 Sep 2001, 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?
   > 
   > Geoff
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 6: Have you searched our list archives?
   > 
   > http://archives.postgresql.org
   > 
   > 
   
   
   

3. Re: Changing data types

   Hannu Krosing <hannu@tm.ee> — 2001-09-24T15:03:38Z

   "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?
   
   create temptable
    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.
   
   ---------------
   Hannu