<quote who="renzo rizzato">
> does anybody know if any sql instruction exists to allow
> change of a column data type? In my case I need to convert a
> money type into numeric without any success.
AFAIK you cannot in Postgresql. I suggest you recreate the table with the
correct column datatypes (i.e. rename the table, create the new table and
populate it with values from the original table.) Watch out for triggers and
procedures.
Regards,
Alberto.