PostgrestQueryBuilder | /mod.ts | supabase@1.3.1

method PostgrestQueryBuilder.prototype.upsert

Re-export

import { PostgrestQueryBuilder } from "https://deno.land/x/supabase@1.3.1/mod.ts";

upsert(values: Partial<T> | Partial<T>[], unnamed 1?: { onConflict?: string; returning?: "minimal" | "representation"; count?:

| null

| "exact"

| "planned"

| "estimated"

; ignoreDuplicates?: boolean; }): PostgrestFilterBuilder<T>

Performs an UPSERT into the table.

Parameters

values: Partial<T> | Partial<T>[]

The values to insert.

optional

unnamed 1: { onConflict?: string; returning?: "minimal" | "representation"; count?:

| null

| "exact"

| "planned"

| "estimated"

; ignoreDuplicates?: boolean; } = [UNSUPPORTED]

By specifying the on_conflict query parameter, you can make UPSERT work on a column(s) that has a UNIQUE constraint.