Situation: The column type was a character (or another kind of type) instead of character varying. 

Solution:

ALTER TABLE [table_name] ALTER COLUMN [column_name] TYPE [wanted_type]

example:

ALTER TABLE plants ALTER COLUMN sun_exposure TYPE character varying(50)