Re: [GENERAL] change data type from text to numeric

On Wed, 26 Nov 2014 15:40:53 -0600 Daniel Torres wrote: > 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_na

Re: [GENERAL] change data type from text to numeric

Daniel Torres wrote > 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

[GENERAL] change data type from text to numeric

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 conver