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