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
|