postgresql alter column type and default code example Example: postgresql change column type ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;