How to extract only numerics from string in PostgreSQL 8.0.2 Amazon Redshift

I only want the numeric part of this string column: identity studen开发者_StackOverflow社区t:1234 student:56