Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group