Re: change existing table definition

From: Chuming Chen <chen(at)musc(dot)edu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: change existing table definition
Date: 2005-06-28 14:39:59
Message-ID: 42C1613F.4000605@musc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.* ?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Browne 2005-06-28 15:25:29 Re: Poolin' it
Previous Message Michael Fuhr 2005-06-28 14:31:06 Re: change existing table definition