Re: Changing columns descriptions...

2008-12-30 Thread Olaf Stein
Just use the same type as the column already has... Olaf On 12/30/08 12:40 PM, "Carlos Savoretti" wrote: > Hi all: > > Is it possible to change a column description > _without_ having to reset its type ? It is, > I has not to change its type, just its comment ... > > Example: > ALTER TABLE p

Changing columns descriptions...

2008-12-30 Thread Carlos Savoretti
Hi all: Is it possible to change a column description _without_ having to reset its type ? It is, I has not to change its type, just its comment ... Example: ALTER TABLE products CHANGE COLUMNS product_id product_id INTEGER COMMENT 'Foo'; In Postgresql, it's done with: COMMENT ON COLUMN products