X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 37A7ED1B94F for ; Tue, 2 Sep 2003 09:50:51 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 44525-03 for ; Tue, 2 Sep 2003 06:50:21 -0300 (ADT) Received: from chn-dns.primus-india.net (unknown [203.196.153.7]) by svr1.postgresql.org (Postfix) with ESMTP id 699CFD1B8F5 for ; Tue, 2 Sep 2003 06:50:17 -0300 (ADT) Received: from IVESIA67 (ptil-138-190-chn.primus-india.net [203.196.190.138] (may be forged)) by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id h829QOnm014642 for ; Tue, 2 Sep 2003 14:56:27 +0530 Message-ID: <000c01c37137$a6e87ce0$7502a8c0@hdsc.com> From: "Senthil Kumar S" To: "psql" Subject: Change column data type Date: Tue, 2 Sep 2003 15:20:29 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C37165.BE623A90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_50_60 X-Spam-Level: X-Archive-Number: 200309/17 X-Sequence-Number: 14995 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C37165.BE623A90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, Using Postgres 7.3.4 over the linux server 7.3.=20 Is it possible to alter/change the data type of a existing table's column, = with out dropping and recreating a column of same name. Thanks for ur knowledge sharing. Regards Kumar ------=_NextPart_000_0007_01C37165.BE623A90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Friends,
 
Using Postgres 7.3.4 over the linux server 7.3. =
 
Is it possible to alter/change the data type of a exist= ing=20 table's column, with out dropping and recreating a column of same=20 name.
 
Thanks for ur knowledge sharing.
 
 
Regards
Kumar
 

------=_NextPart_000_0007_01C37165.BE623A90--