Re: Alter definition of a column

Should help --> ALTER TABLE tablename ALTER columname TYPE text;

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

On 1/20/07, Kelly Burkhart <kelly(dot)burkhart(at)gmail(dot)com> wrote:
>
> On 1/19/07, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> >
> > ALTER TABLE, to be correct, actually has to check the entire table to
> > make sure it's ok. By doing it directly you're basically telling the DB
> > it's OK.
> >
> > For making a varchar column longer it's safe though, and the easiest
> way.
>
> Is it possible to use a similar method to change a varchar(n) to text
> with no length constraint?
>
> -K
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>