Tomas's suggestion definitely is the better if you're altering the
type of a single column. If you need to make more extensive changes
to the table structure, copying usually is the better way to go.
George
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general