changing column size in postgres - Mailing list pgsql-admin

hello

How do i change the definition of  a column? one of the columns width is not sufficient to store the data. I want to change the width. how to do that in postgres? I tried doing alter table + change/modify. both of them doesn't work in postgres.

   and what is the maximum size to which a postgres database can grow? I have huge data to store.

regards

sharvari