From: Shoaib Mir <shoaibmir@gmail.com>
To: Kumar Dev <kumardb2@gmail.com>
Cc: Judith <jaltamirano@correolux.com.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re: Change of data type
Date: Fri, 11 Aug 2006 00:49:33 +0500
Message-ID: <bf54be870608101249u74998c89k7cf3398ccf31e162@mail.gmail.com> (raw)
In-Reply-To: <9dafed310608071345p15d5bbafxba9acfddd116320f@mail.gmail.com>
References: <44D77A8C.9040303@correolux.com.mx>
<9dafed310608071345p15d5bbafxba9acfddd116320f@mail.gmail.com>
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@gmail.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@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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shoaibmir@gmail.com, kumardb2@gmail.com, jaltamirano@correolux.com.mx
Subject: Re: Change of data type
In-Reply-To: <bf54be870608101249u74998c89k7cf3398ccf31e162@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox