Hi Desmond !
I use 'pg_dump -c my_db > my_db_dump' and then edit the dump file's CREATE
TABLE statements to change column data-tytes. When done, read or re-create
the db back in with 'cat my_db_dump | psql my_db'
Just make sure your data fits into the new data-type.
BR,
Aarni