# [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