Alter Column

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Alter Column
Date: 2004-10-27 08:43:43
Message-ID: 1098866625.3186.16.camel@retsol1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2004-10-27 08:58:23 Re: Alter Column
Previous Message ishaame 2004-10-27 07:06:47 Cannot Create tables - on Windows XP