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

Re: change column after creation?

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 (view raw, whole thread or download thread mbox)
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)

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
>voice:  306.569.7790
>fax:  306.949.0430

pgsql-novice by date

Next:From: davidbDate: 2000-05-31 15:27:42
Subject: Re: Suggest a query
Previous:From: JosephDate: 2000-05-31 10:19:53
Subject: Upgrade Questions

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