How can I alter the type of a money-column to decimal in PostgreSQL?

2 votes

1 answer

3258 views

                          I have a table in PostgreSQL where one column "vat" has type money but I would like to alter it to decimal instead.

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

Any suggestions?

Asked by Jonas (33975 rep)

May 23, 2011, 03:25 PM
Last activity: May 23, 2011, 10:12 PM

How can I alter the type of a money-column to decimal in PostgreSQL?

Related Questions