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

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

pgsql-admin by date

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

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