From: | davidb(at)vectormath(dot)com |
---|---|
To: | "James M (dot) Burton" <jburton(at)bfsmedia(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: change column after creation? |
Date: | 2000-05-31 15:18:32 |
Message-ID: | 004e01bfcb13$7d3bc730$0602010a@bullwinkle.vectormath |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | davidb | 2000-05-31 15:27:42 | Re: Suggest a query |
Previous Message | Joseph | 2000-05-31 10:19:53 | Upgrade Questions |