How to Get the Second Sequence of Characters using Regular Expressions
postgres=# select substring('68 TIDAL BREEZE DR' from '\s+(.*)\s');
  substring
--------------
 TIDAL BREEZE
(1 row)


Lazy match the first whitespace character to chop the first bit off.