Answers for "convert string to int postgres"

postgres change column type string to integer

ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);

Posted by: Guest on June-01-2021

postgres convert text to number

SELECT ' 5800.79 '::INTEGER;

Posted by: Guest on January-21-2021

postgresql cast

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

Posted by: Guest on October-12-2020

Code answers related to "convert string to int postgres"