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
