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