CODE EXAMPLE FOR SQL

how to alter length character varying postgres

alter table TABLE_NAME alter column COLUMN_NAME type character varying(120);