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:
> 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.
In response to
pgsql-novice by date
|Next:||From: ishaame||Date: 2004-10-27 09:33:29|
|Subject: Re: Cannot Create tables - on Windows XP|
|Previous:||From: Steve Tucknott||Date: 2004-10-27 08:43:43|
|Subject: Alter Column|