Re: change existing table definition

On Tuesday 28 June 2005 15:27, Chuming Chen wrote:

Hello,

> How can I change the column definition of an existing table, ie. from
> varchar(30) to varchar(50)?

You did not mention any version, so for 8.0.x:

alter table t alter col type varchar(50);

> Is there any way to add a new column to an
> existing table?

alter table t add colum foo varchar(127)

Link tip:

http://www.postgresql.org/docs/8.0/interactive/ddl-alter.html

HTH

Johannes