Python: Insert data

Parameters

• json

  (Required)

  The values to insert. Pass an dict to insert a single row or an list to insert multiple rows.

• count

  (Optional)

  The property to use to get the count of rows returned.

• returning

  (Optional)

  Either 'minimal' or 'representation'. Defaults to 'representation'.

• default_to_null

  (Optional)

  Make missing fields default to `null`. Otherwise, use the default value for the column. Only applies for bulk inserts.

Examples

Create a record

response = (
    supabase.table("countries")
    .insert(\{"id": 1, "name": "Denmark"\})
    .execute()
)

Bulk create

try:
  response = supabase.table("countries")
    .insert([
      \{ "id": 1, "name": "Nepal" \},
      \{ "id": 1, "name": "Vietnam" \},
    ])
    .execute()
  return response
except Exception as exception:
  return exception