# [EMAIL PROTECTED] / 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to