Re: change existing table definition

Chuming Chen wrote:

> Peter Eisentraut wrote:
>
>> Chuming Chen wrote:
>>
>>
>>> How can I change the column definition of an existing table, ie. from
>>> varchar(30) to varchar(50)? Is there any way to add a new column to
>>> an existing table?
>>>
>>
>>
>> The ALTER TABLE command can do all that.  You need version 8.0 or
>> later for some functionality though.
>>
>>
>>
> Is there another way to do it in 7.* ?
>

http://www.postgresql.org/docs/faqs.FAQ.html#4.3

> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.