Thread: Alter Column

Alter Column

From
Steve Tucknott
Date:
PostgreSQL 7.4.5

Is there a simple way of altering the definition of a column?

Say I have a column defined as CHAR(5) and I want to make that CHAR(10) NOT NULL - apart from creating a second table and copying the table, dropping the original and renaming the copy.

What I am hoping for is 'yes, V8 has ALTER TABLE MODIFY (colName     definition) '  ;-)


Regards,

Steve Tucknott

ReTSol Ltd

DDI: 01903 828769

Re: Alter Column

From
Michael Fuhr
Date:
On Wed, Oct 27, 2004 at 09:43:43AM +0100, Steve Tucknott wrote:
> PostgreSQL 7.4.5
>
> Is there a simple way of altering the definition of a column?
>
> Say I have a column defined as CHAR(5) and I want to make that CHAR(10)
> NOT NULL - apart from creating a second table and copying the table,
> dropping the original and renaming the copy.

This is answered in the FAQ:

http://www.postgresql.org/docs/faqs/FAQ.html#4.4

> What I am hoping for is 'yes, V8 has ALTER TABLE MODIFY (colName
> definition) '  ;-)

In 8.0 you can change a column's type with ALTER TABLE.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/