how to convert text to integer in postgres sql code example Example: postgres convert text to number SELECT ' 5800.79 '::INTEGER;