X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0A5429FB29D for ; Tue, 8 Aug 2006 06:51:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 71453-02 for ; Tue, 8 Aug 2006 09:51:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from isis.sigpipe.cz (fw.sigpipe.cz [62.245.70.224]) by postgresql.org (Postfix) with ESMTP id 44E099FA374 for ; Tue, 8 Aug 2006 06:51:54 -0300 (ADT) Received: from dagan.sigpipe.cz (dagan.sigpipe.cz [10.9.8.90]) by isis.sigpipe.cz (Postfix) with ESMTP id 295E31F87BF2; Tue, 8 Aug 2006 11:51:53 +0200 (CEST) Received: by dagan.sigpipe.cz (Postfix, from userid 1001) id C166E2C91A4; Tue, 8 Aug 2006 11:51:56 +0000 (UTC) Date: Tue, 8 Aug 2006 11:51:56 +0000 From: Roman Neuhauser To: Judith Cc: pgsql-sql@postgresql.org Subject: Re: Change of data type Message-ID: <20060808115156.GA8393@dagan.sigpipe.cz> References: <44D77A8C.9040303@correolux.com.mx> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44D77A8C.9040303@correolux.com.mx> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/46 X-Sequence-Number: 26004 # jaltamirano@correolux.com.mx / 2006-08-07 12:38:20 -0500: > Hello everybody, excuse me how can I change de data type of a field, > I currently have: > > material character(30) > > but I now want the field in text type like this: > > material text > > somebody knows if ALTER TABLE has some option to do this?, or How > can I do that? http://www.postgresql.org/docs/8.1/static/sql-altertable.html -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991