$ psql service=staging-swh -c "select convert_from(name, 'utf-8') as bname, rev.metadata from snapshot s inner join snapshot_branches sbs on sbs.snapshot_id=s.object_id inner join snapshot_branch sb on sbs.branch_id=sb.object_id inner join revision rev on (rev.id=sb.target and sb.target_type='revision') where s.id='\x757b6422d07b0f50f983d86b0eef192ef248ca0b'" > output.txt