How to extract a portion of a URL in PostgreSQL
I'm trying to extract only a certain portion of a string URL field in my query. I am doing this in Amazon Redshift. The query is very simple, essentially SELECT email_id, url FROM emailsends WHERE date > '01-01-2023' Pretty simple…