On Tue, Nov 30, 2004 at 11:16:39AM +0530, Nageshwar Rao wrote: > I would like to change the column length from varchar(10) to varchar(30).How > this can be done.
Changing a column's type is discussed in the FAQ: http://www.postgresql.org/docs/faqs/FAQ.html#4.4 In PostgreSQL 8.0 you'll be able to use ALTER TABLE. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html