Hi,
I have an app that I released with a particular field as varchar 255.
Can someone give me a script example I can use to make an upgrade script to change it to text or at least to larger varchar without losing existing data?
Others have answered for version 8.
If you are running one of the 7.x releases, you should google for "pg_attribute atttypmod" and see how you can change that value to extend varchars.
HTH
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)