changing the size of a column without losing data

From: "Mark Seftel" <mark(at)trustemail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: changing the size of a column without losing data
Date: 2002-08-22 17:43:57
Message-ID: IOEPIFKAFJKHALEOJJHEKEEOCNAA.mark@trustemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message JDK 2002-08-22 18:08:24 Re: Enforcing Case
Previous Message Rod Kreisler 2002-08-22 15:52:53 Re: Enforcing Case