Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1N2XKx51063 for ; Thu, 22 Feb 2001 21:33:20 -0500 (EST) (envelope-from pgsql-docs-owner@postgresql.org) Received: from hotmail.com (f36.pav1.hotmail.com [64.4.31.36]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1HJ4sx31925 for ; Sat, 17 Feb 2001 14:04:54 -0500 (EST) (envelope-from felixonta@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 17 Feb 2001 11:04:52 -0800 Received: from 62.83.92.35 by pv1fd.pav1.hotmail.msn.com with HTTP; Sat, 17 Feb 2001 19:04:52 GMT X-Originating-IP: [62.83.92.35] From: "=?iso-8859-1?B?Sm9zZSBGZWxpeCBPbnRh8W9uIENhcm1vbmE=?=" To: pgsql-docs@postgresql.org Subject: a little question Date: Sat, 17 Feb 2001 20:04:52 +0100 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 17 Feb 2001 19:04:52.0657 (UTC) FILETIME=[820BA210:01C09914] X-Archive-Number: 200102/116 X-Sequence-Number: 374 please, i've just change from oracle to postgres. I've read documentation aboutthe "alter table" sentence and my question is: How can I change the type of a column of a db? I want to change from int4 to varchar(20) Thanx for all. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.