i am unable to change data type for population in postgre sql . This is the error im receiving. I have tried all data type options
ERROR: column “population” cannot be cast automatically to type double precision HINT: You might need to specify “USING population::double precision”.
i changed from varchar to float, numeric,int,bigint
New contributor
Abigail Ofosu is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.