You can do the following:ALTER TABLE table-name ALTER colum-name TYPE text;Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)
On 8/8/06, Kumar Dev <[EMAIL PROTECTED]> wrote:
Use Alter table notebook from control center
right click on the table and open alter table notebook
you can drop a colum
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 <[EMAIL PROTECTED]> wrote:
Hello everybody, excuse me how can I change de data type of a field,I currently h
# [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 h
On pg8, to change tab.col to type t:
alter table tab alter column col type t
so:
alter table tab alter column material type text
-j
Judith 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 fi
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?
-
