How to parse host out of a string in Redshift?


I'm looking for a Postgres (actually Redshift) equivalent to Hive's parse_url(..., 'HOST').

Postgres docs say it has a URL parser as part of its full text search. This blog post has a regex which may or may not be bulletproof. What is best?

By : dfrankow

This video can help you solving your question :)
By: admin