Received: from exchange.iweb.co.il ([212.68.138.186]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5Q7dMa87156 for ; Tue, 26 Jun 2001 03:39:23 -0400 (EDT) (envelope-from ilan@iweb.com) Received: by EXCHANGE with Internet Mail Service (5.5.2653.19) id ; Tue, 26 Jun 2001 10:41:04 +0300 Message-ID: From: Ilan Fait To: "'Pgsql-Sql (E-mail)" Subject: Changing datatype of a column Date: Tue, 26 Jun 2001 10:41:03 +0300 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C0FE13.59F758F0" X-Archive-Number: 200106/409 X-Sequence-Number: 3706 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0FE13.59F758F0 Content-Type: text/plain; charset="windows-1255" Hi, I would like to Know if there any way (and what is the command for that) to convert a column datatype from int4 to numeric(11) of an existing table that have data in it? Thanks, Ilan _________________________________________ ILAN FAIT Tel: 972-9-9519133 Ex.247 iWeb Technologies Fax: 972-9-9519134 91 Medinat Ha'Yehudim St. Herzliya 46120 IL mailto:ilan@iweb.com www.iweb.com ------_=_NextPart_001_01C0FE13.59F758F0 Content-Type: text/html; charset="windows-1255" Content-Transfer-Encoding: quoted-printable Changing datatype of a column

       =        Hi,

       =        I would like to Know if there any way = (and what is the command for that)  to convert a column datatype
       = ;       from int4 to numeric(11)  of an = existing table that have data in it?
       = ;      
       = ; 
       = ;      Thanks,
       = ;      Ilan

 
____________________= _____________________
ILAN FAIT
Tel: 972-9-951= 9133  Ex.247    iWeb Technologies
Fax: 972-9-951= 9134            = ;    91 Medinat Ha'Yehudim St.
  &n= bsp;            = ;            &n= bsp;            = ;             H= erzliya 46120 IL
mailto:ilan@iweb.com    www.iweb.com<= /FONT>


------_=_NextPart_001_01C0FE13.59F758F0--