\set ECHO none -- You should write your tests SELECT jsonrpc.execute('{"jsonrpc": "2.0", "id":1, "method":"echo", "params": {"message": "Hello jsonrpc!"}}'); {"id" : "1", "jsonrpc" : "2.0", "result" : "Hello jsonrpc!"} INSERT INTO jsonrpc.methods(name, description, function_name) VALUES('echotest', 'Echoes the parameter passed to echo.', 'jsonrpc.echo'); SELECT jsonrpc.execute('{"jsonrpc": "2.0", "id":1, "method":"echotest", "params": {"message": "Hello jsonrpc!"}}'); {"id" : "1", "jsonrpc" : "2.0", "result" : "Hello jsonrpc!"} ROLLBACK;