how to change the type of the table postgresql code example

Example: postgresql change column type

ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;