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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
