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 ...