Simple PLV8

gistfile1.sql

DO $$ 
	var json_result = plv8.execute( 'SELECT * FROM snapshot' );
	var results = [];
	json_result.forEach(function(r){
		if(r.blob && r.blob.archive.indexOf('824149b96bb9')){
				plv8.elog(NOTICE, JSON.stringify(r)); 
		}
	});
	plv8.elog(NOTICE, 'length', json_result.length) 

$$ LANGUAGE plv8;