Re: Change of data type

You can do the following:

ALTER TABLE table-name ALTER colum-name TYPE text;

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 8/8/06, Kumar Dev <kumardb2(at)gmail(dot)com> wrote:
>
> Use Alter table notebook from control center
> right click on the table and open alter table notebook
> you can drop a column or add a column or change the datatype
>
> Kumar
>
>
> On 8/7/06, Judith <jaltamirano(at)correolux(dot)com(dot)mx> wrote:
> >
> > 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?
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> >
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
>
>
> --
> Kumar
> DB2 DBA & SAP Basis professional
>