Re: change existing table definition - Mailing list pgsql-admin

From Chuming Chen
Subject Re: change existing table definition
Date
Msg-id 42C1613F.4000605@musc.edu
Whole thread Raw
In response to Re: change existing table definition  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: change existing table definition  ("Martin Fandel" <martin.fandel@alphyra-evs.de>)
Re: change existing table definition  (Brad Nicholson <bnichols@ca.afilias.info>)
List 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.* ?

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


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: change existing table definition
Next
From: Michael Fuhr
Date:
Subject: Re: change existing table definition