Skip to main content
  • Adds multiple records to the specified table. The operation is synchronous, meaning that a response will not be returned until all the records are fully inserted and available. The response payload provides the counts of the number of records actually inserted and/or updated, and can provide the unique identifier of each added record.

    The options parameter can be used to customize this function’s behavior.

    The update_on_existing_pk option specifies the record collision policy for inserting into a table with a primary key, but is ignored if no primary key exists.

    The return_record_ids option indicates that the database should return the unique identifiers of inserted records.

    Parameters

    • table_name: string

      Name of table to which the records are to be added, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table.

    • data: Record<string, any>[]

      Data records to process

    • Optionaloptions: Record<string, string>

      Optional parameters.

    • Optionalcallback: GPUdbCallback

      Optional callback function

    Returns Promise<InsertRecordsResponse>

    Promise<Types.InsertRecordsResponse> - Promise resolving to the response

  • Adds multiple records to the specified table. The operation is synchronous, meaning that a response will not be returned until all the records are fully inserted and available. The response payload provides the counts of the number of records actually inserted and/or updated, and can provide the unique identifier of each added record.

    The options parameter can be used to customize this function’s behavior.

    The update_on_existing_pk option specifies the record collision policy for inserting into a table with a primary key, but is ignored if no primary key exists.

    The return_record_ids option indicates that the database should return the unique identifiers of inserted records.

    Parameters

    Returns Promise<InsertRecordsResponse>

    Promise<Types.InsertRecordsResponse> - Promise resolving to the response