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. -- Peter Eisentraut http://developer.postgresql.org/~petere/