ALTER TABLE .... ALTER column TYPE varchar(xxx) We need to increase the length of a varchar(256) column in two of our largest tables preferrably to TEXT.
Is there a way to do this without having to go through a complete table rewrite? I have googled and seen the todo on the wiki, but I'm wondering if we are increasing the length of a varchar column can we manually modify the system catalogs to increase the length? http://wiki.postgresql.org/wiki/Todo#ALTER Version: PG 8.1.17 Thanks, Eric -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin