PostgreSQL isNumeric() ?

Here’s a very simple way you can check if a bunch of text is numeric.

select (’9339′ ~ ‘^[0-9]+$’);
select (’93a39′ ~ ‘^[0-9]+$’);

The first should return true, the second false.