ERROR: column graduation_year cannot be cast automatically to type integer HINT: You might need to specify USING graduation_year::integer. code example

Example: Datatype mismatch: 7 ERROR: column cannot be cast automatically to type integer

alter table a.attend alter column terminal TYPE INTEGER  USING (terminal::integer) ;