Select Basename in Postgres SQL
Postgres doesn't have a basename function per se. But it's easy to accomplish.
select regexp_replace('http://www.seanbehan.com/images/logo.png', '.+/', '') ;
-- Will return logo.png
Postgres doesn't have a basename function per se. But it's easy to accomplish.
select regexp_replace('http://www.seanbehan.com/images/logo.png', '.+/', '') ;
-- Will return logo.png
Nice. Just what i needed!