Re: Change of data type - Mailing list pgsql-sql

From Roman Neuhauser
Subject Re: Change of data type
Date
Msg-id 20060808115156.GA8393@dagan.sigpipe.cz
Whole thread Raw
In response to Change of data type  (Judith <jaltamirano@correolux.com.mx>)
List pgsql-sql
# 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


pgsql-sql by date:

Previous
From: jason nordwick
Date:
Subject: Re: Change of data type
Next
From: "Jonathan Sinclair"
Date:
Subject: Query response time