Fw: change column after creation?

Of course, you can always copy to a temporary table, then drop and recreate
the original table.

I neglected to mention this earlier.

David Boerwinkle
-----Original Message-----
From: davidb(at)vectormath(dot)com <davidb(at)vectormath(dot)com>
To: James M . Burton <jburton(at)bfsmedia(dot)com>; pgsql-novice(at)postgresql(dot)org
<pgsql-novice(at)postgresql(dot)org>
Date: Wednesday, May 31, 2000 10:18 AM
Subject: Re: [NOVICE] change column after creation?

>Hello Mr. Burton,
>
>I am fairly sure that the only column altering operations that Postgres
>currently supports are changing the name and the default value. (look
under
>alter table in the docs)
>
>Sorry,
>David Boerwinkle
>
>
>-----Original Message-----
>From: James M . Burton <jburton(at)bfsmedia(dot)com>
>To: pgsql-novice(at)postgresql(dot)org <pgsql-novice(at)postgresql(dot)org>
>Date: Tuesday, May 30, 2000 7:27 PM
>Subject: [NOVICE] change column after creation?
>
>
>>is it possible to change or alter a column after it is created?
>>
>>i created a column that i set at 50 characters and would like to change
>that to a higher number.
>>
>>is there some way of doing that? i only ever come across "alter column"
in
>the todo lists for postgresql but have not come across a syntax example in
>normal docs.
>>
>>
>>--
>>James M. Burton
>>jburton(at)bfsmedia(dot)com
>>voice: 306.569.7790
>>fax: 306.949.0430
>