Re: change existing table definition

On Tue, Jun 28, 2005 at 09:27:32AM -0400, 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?

See ALTER TABLE in the documentation and "How do you change a
column's data type?" in the FAQ:

http://www.postgresql.org/docs/8.0/static/sql-altertable.html
http://www.postgresql.org/docs/faqs.FAQ.html#4.3

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/