How can a string value be converted to an integer type in PostgreSQL?

In PostgreSQL, to convert a string value to an integer type, you can use the cast operator ::integer or the CAST function.

Examples:

SELECT '123'::integer;  -- Result: 123

SELECT CAST('456' AS integer);  -- Result: 456

If the string cannot be correctly converted to a number, a runtime error will occur.