Change of data type

From: Judith <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: Change of data type
Date: 2006-08-07 17:38:20
Message-ID: 44D77A8C.9040303@correolux.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message George Young 2006-08-07 19:20:31 Re: viewing the description of tables from python DB-API
Previous Message Lexington Luthor 2006-08-07 15:38:37 Querying constraints?