Hi everyone,
sorry to bother you with a simple question, (I'm a new user of postgresql),
how do I change the data type of a column of text, to numeric or integer?
I tried with:
ALTER TABLE table_name
ALTER COLUMN col_name TYPE integer
;
It gives me a mistake
ERROR: la columna no puede convertirse automáticamente al tipo integer
SUGERENCIA: Especifique una expresión USING para llevar a cabo la
conversión.
translation: the column can't be converted automatically to type integer
.... specify an expression using USING to make the conversion.
I also tried on pgadmin3, but couldn't found how to do it...
thanks,
Daniel