On Wed, 5 Dec 2001, tinar wrote:
> i have created a table
> userlist with fields username varchar(10)
> now i want to change it to username varchar(30)
> without dropping or recreating the table.
> how do i do it?
The best way is to recreate the table and rename
them around. If you *REALLY* don't want to do
that and have a recent backup (yes, I'm serious),
you can muck with pg_attribute and change
atttypmod for the attribute in question
(from 14 to 34).