CREATE FUNCTION func_FugaTable(key text) RETURNS TABLE(col1 text, col2 text) AS $$ DECLARE sql TEXT; BEGIN sql := 'SELECT id::text, name::text FROM t_Fuga WHERE id = ''' || key || ''''; RETURN QUERY EXECUTE sql; END; $$ LANGUAGE plpgsql;