Unsigned integer float postgres

postgres float int

SELECT CAST(float_to_convert AS INTEGER) FROM your_table;
-- Or
SELECT float_to_convert::integer FROM your_table;