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

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@correolux.com.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@postgresql.org so that your
      message can get through to the mailing list cleanly

--
Kumar
DB2 DBA & SAP Basis professional