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

On Wed, Oct 27, 2004 at 09:43:43AM +0100, Steve Tucknott wrote:
This is answered in the FAQ:

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

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

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly