Specifies the method to use when inserting bulk data. By default, the DML mode is used.

Syntax

Connect-PostgreSQL -InsertMode string

Possible Values

Data Type

cstr

Default Value

"DML"

Remarks

There are only two valid options: DML and CSVStream.

When InsertMode is set to DML, the cmdlet uses INSERT SQL statements to upload bulk data.

When this property is set to CSVStream, the cmdlet employs the bulk upload with the COPY FROM STDIN command.