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/