how to change the datatype of column in postgres code example Example: postgresql change column type ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;