alter the table query for postgres code example

Example: alter column in table postgres

ALTER TABLE table_name
  ALTER COLUMN column_name TYPE column_definition;