Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 47DDE476C0B for ; Tue, 7 May 2002 12:47:23 -0400 (EDT) Received: from ryloth.acucore.com (unknown [65.204.194.43]) by postgresql.org (Postfix) with SMTP id 330B6476832 for ; Tue, 7 May 2002 11:08:01 -0400 (EDT) Received: (qmail 21423 invoked by uid 508); 7 May 2002 15:20:35 -0000 Received: from phppgadmin@acucore.com by ryloth.acucore.com by uid 505 with qmail-scanner-1.10 (spamassassin. Clear:0. Processed in 0.225033 secs); 07 May 2002 15:20:35 -0000 Received: from localhost (127.0.0.1) by 0 with SMTP; 7 May 2002 15:20:34 -0000 Received: from 207.135.57.77 ( [207.135.57.77]) as user dwilson@acucore.com@localhost by webmail.acucore.com with HTTP; Tue, 7 May 2002 09:20:34 -0600 Message-ID: <1020784834.3cd7f0c2945e5@webmail.acucore.com> Date: Tue, 7 May 2002 09:20:34 -0600 From: Dan Wilson To: ameen eetemadi Cc: pgsql-php@postgresql.org Subject: Re: type of a field MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) 4.0-cvs X-Spam-Status: No, hits=0.0 required=5.0 tests= version=2.20 X-Spam-Level: X-Archive-Number: 200205/38 X-Sequence-Number: 1170 You can't yet... at least not with an ALTER statement. The only way to currenty do this is by dumping the table (through pg_dump), altering the type of the field, and then re-ipmorting the table. Rumor has it that they are working on an ALTER statement to accomplish this for 7.3 or 7.4. -Dan Quoting ameen eetemadi : > I want to change the type of a field in postgres . > How can I do it ?