postgresql cast column type code example

Example 1: postgresql change column type

ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;

Example 2: postgresql cast

SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);