Cmdlets for PostgreSQL

Build 24.0.9060

InsertMode Parameter (Connect-PostgreSQL Cmdlet)

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

Syntax

Connect-PostgreSQL -InsertMode string

Possible Values

DML, CSVStream

Data Type

cstr

Default Value

"DML"

Remarks

When this is set to DML the cmdlet uses Insert SQL statements to upload bulk data.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060