You will be be redirected to the blog in a moment...

Or you can click the link below to proceed:
How to convert a char column to numeric in PostgreSQL

Attempting to ALTER a char column directly to numeric will result in the following error: ERROR: column “COL_NAME̶ 1; cannot be cast to type numeric Here’s how to get around that: Verify data is ok & delete away the old column. I blog about PostgreSQL and other Linux sys admin stuffs on my Twitter (@uzyn) and ...

 

Want to be redirected immediately?
Register yourself at Ping.sg to get rid of this page and also to get your read counted as Pong.