Should help --> ALTER TABLE tablename ALTER columname TYPE text;
---------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/20/07, Kelly Burkhart <[EMAIL PROTECTED]> wrote:
On 1/19/07, Martijn van Oosterhout <kleptog@svana.org> wrote: > > ALTER TABLE, to be correct, actually has to check the entire table to > make sure it's ok. By doing it directly you're basically telling the DB > it's OK. > > For making a varchar column longer it's safe though, and the easiest way. Is it possible to use a similar method to change a varchar(n) to text with no length constraint? -K ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
