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 whole 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
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
>alter table in the docs)
>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"
>the todo lists for postgresql but have not come across a syntax example in
>normal docs.
>>James M. Burton
>>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-2015 The PostgreSQL Global Development Group