Re: change existing table definition - Mailing list pgsql-admin

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/