You can cast it to a supported type by PostgreSQL CAST() You can cast it to a supported type by PostgreSQL CAST() code example

Example: postgresql cast

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