v_query := 'INSERT INTO ps.tbl_psearch_' || v_partition || '(pse_id, pse_uid, pse_nt, pse_type, pse_last) VALUES ' || '(' || COALESCE(quote_literal(NEW.pse_id), 'NULL') || ',' || COALESCE(quote_literal(NEW.pse_uid), 'NULL') || ',' || COALESCE(quote_literal(NEW.pse_nt), 'NULL') || ',' || COALESCE(quote_literal(NEW.pse_type), 'NULL') || ',' || COALESCE(quote_literal(NEW.pse_last), 'NULL') || ')'; EXECUTE v_query;