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

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

pgsql-novice by date

Next:From: JDKDate: 2002-08-22 18:08:24
Subject: Re: Enforcing Case
Previous:From: Rod KreislerDate: 2002-08-22 15:52:53
Subject: Re: Enforcing Case

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