Raymond O'Donnell wrote: > (i) Create a new column of type numeric or integer as appropriate. > (ii) update your_table set new_column = CAST(trim(both ' 0' from > old_column) as numeric) > (iii) Drop the old column, as well as any constraints depending on it. > (iv) Rename the new column to the same name as the old column > (v) Recreate any of the constraints dropped in step (iii).
Or try in a single step: ALTER TABLE tablename ALTER column column_name TYPE numeric USING column_name::numeric; (replace numeric by the desired type if it's not numeric). Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
