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) ' ;-)
DDI: 01903 828769
pgsql-novice by date
|Next:||From: Michael Fuhr||Date: 2004-10-27 08:58:23|
|Subject: Re: Alter Column|
|Previous:||From: ishaame||Date: 2004-10-27 07:06:47|
|Subject: Cannot Create tables - on Windows XP|