Skip site navigation (1) Skip section navigation (2)

Fw: change column after creation?

From: davidb(at)vectormath(dot)com
To: <jburton(at)bfsmedia(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Fw: change column after creation?
Date: 2000-05-31 15:41:17
Message-ID: 00ab01bfcb16$aa7f9430$0602010a@bullwinkle.vectormath (view raw or flat)
Thread:
Lists: pgsql-novice
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
>


pgsql-novice by date

Next:From: Thomas WeholtDate: 2000-06-02 06:07:14
Subject: Performance - fsync-off
Previous:From: davidbDate: 2000-05-31 15:27:42
Subject: Re: Suggest a query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group