I have a table in PostgreSQL where one column "vat" has type
money but I would like to alter it to
How can I do it?
I tried with:
alter table my_table alter column vat type decimal;
But I get this error:
ERROR: column "vat" cannot be cast to type numeric