On Tue, Dec 16, 2003 at 12:32:05PM -0500, Jodi Kanter wrote: > Can I alter a column from character varying(128) to text without having > to create a temp table? I am running 7.3.3.
The FAQ has a question entitled "How do you remove a column from a table, or change its data type?": http://www.postgresql.org/docs/faqs/FAQ.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
