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 185CC9FB228 for ; Mon, 7 Aug 2006 17:38:19 -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 24651-02 for ; Mon, 7 Aug 2006 20:38:15 +0000 (UTC) X-Greylist: delayed 02:59:57.506582 by SQLgrey- Received: from CORREO.correolux.com.mx (customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218]) by postgresql.org (Postfix) with ESMTP id 1B1229FB1EF for ; Mon, 7 Aug 2006 17:38:14 -0300 (ADT) Received: from [192.168.7.58] ([192.168.7.58]) by correolux.com.mx with MailEnable ESMTP; Mon, 07 Aug 2006 12:40:57 -0600 Message-ID: <44D77A8C.9040303@correolux.com.mx> Date: Mon, 07 Aug 2006 12:38:20 -0500 From: Judith User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: es-es, es MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Change of data type Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/44 X-Sequence-Number: 26002 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?