Thread

Fw: change column after creation?

davidb@vectormath.com — 2000-05-31T15:41:17Z

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@vectormath.com <davidb@vectormath.com>
To: James M . Burton <jburton@bfsmedia.com>; pgsql-novice@postgresql.org
<pgsql-novice@postgresql.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@bfsmedia.com>
>To: pgsql-novice@postgresql.org <pgsql-novice@postgresql.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@bfsmedia.com
>>voice:  306.569.7790
>>fax:  306.949.0430
>