changing the size of a column without losing data - Mailing list pgsql-novice

hi,

How would i change a field which is currently char100 to char50?

have tried:
ALTER TABLE outlets MODIFY description varchar(50);

but get error:
parser: parse error at or near "modify"

what is the correct command.

Thx

Mark