OS Manuals

/usr/bin/timescaledb-parallel-copy

A binary for parallel copying of CSV data into a TimescaleDB hypertable (FIPS)

From timescaledb-parallel-copy-fips 0.13.1-r3 (enterprise-packages), captured 2026-11-08 by running timescaledb-parallel-copy --help (exit 0). permalink

Usage of /usr/bin/timescaledb-parallel-copy:
  -auto-column-mapping
    	Automatically map CSV headers to database columns with the same names
  -batch-byte-size int
    	Max number of bytes to send in a batch (default 4194304)
  -batch-size int
    	Number of rows per insert. It will be limited by batch-byte-size (default 5000)
  -buffer-byte-size int
    	Number of bytes to buffer, it has to be big enough to hold a full row (default 2097152)
  -column-mapping string
    	Column mapping from CSV to database columns (format: "csv_col1:db_col1,csv_col2:db_col2" or JSON)
  -columns string
    	Comma-separated columns present in CSV
  -connection string
    	PostgreSQL connection url (default "host=localhost user=postgres sslmode=disable")
  -copy-options string
    	Additional options to pass to COPY (e.g., NULL 'NULL') (default "CSV")
  -db-name string
    	(deprecated) Database where the destination table exists
  -disable-direct-compress
    	Disable using direct compress to write data to TimescaleDB
  -disable-windows-1252-handling
    	Disable automatic encoding handling
  -enable-client-side-sorting
    	Guaranteed data order in place on the client side
  -escape character
    	The ESCAPE character to use during COPY (default '"')
  -file string
    	File to read from rather than stdin
  -header-line-count int
    	(deprecated) Number of header lines (default 1)
  -import-id string
    	ImportID to guarantee idempotency
  -limit int
    	Number of rows to insert overall; 0 means to insert all
  -log-batches
    	Whether to time individual batches.
  -no-retry
    	Disable retrying on recoverable errors
  -on-conflict-do-nothing
    	Skip duplicate rows on unique constraint violations
  -quote character
    	The QUOTE character to use during COPY (default '"')
  -reporting-period duration
    	Period to report insert stats; if 0s, intermediate results will not be reported
  -retry-timeout duration
    	Abort retrying recoverable errors after this duration is elapsed (default 5m0s)
  -schema string
    	Destination table's schema (default "public")
  -skip-batch-errors
    	if true, the copy will continue even if a batch fails
  -skip-header
    	Skip the first line of the input
  -skip-lines int
    	Skip the first n lines of the input. it is applied before skip-header
  -split string
    	Character to split by (default ",")
  -table string
    	Destination table for insertions (default "test_table")
  -truncate
    	Truncate the destination table before insert
  -verbose
    	Print more information about copying statistics
  -version
    	Show the version of this tool
  -workers int
    	Number of parallel requests to make (default 1)
Options (33)
OptionDescriptionSource
-auto-column-mappingAutomatically map CSV headers to database columns with the same nameshelp
-batch-byte-size intMax number of bytes to send in a batch (default 4194304)help
-batch-size intNumber of rows per insert.help
-buffer-byte-size intNumber of bytes to buffer, it has to be big enough to hold a full row (default 2097152)help
-column-mapping stringColumn mapping from CSV to database columns (format: "csv_col1:db_col1,csv_col2:db_col2" or JSON)help
-columns stringComma-separated columns present in CSVhelp
-connection stringPostgreSQL connection url (default "host=localhost user=postgres sslmode=disable")help
-copy-options stringAdditional options to pass to COPY (e.g., NULL 'NULL') (default "CSV")help
-db-name string(deprecated) Database where the destination table existshelp
-disable-direct-compressDisable using direct compress to write data to TimescaleDBhelp
-disable-windows-1252-handlingDisable automatic encoding handlinghelp
-enable-client-side-sortingGuaranteed data order in place on the client sidehelp
-escape characterThe ESCAPE character to use during COPY (default '"')help
-file stringFile to read from rather than stdinhelp
-header-line-count int(deprecated) Number of header lines (default 1)help
-import-id stringImportID to guarantee idempotencyhelp
-limit intNumber of rows to insert overall;help
-log-batchesWhether to time individual batches.help
-no-retryDisable retrying on recoverable errorshelp
-on-conflict-do-nothingSkip duplicate rows on unique constraint violationshelp
-quote characterThe QUOTE character to use during COPY (default '"')help
-reporting-period durationPeriod to report insert stats;help
-retry-timeout durationAbort retrying recoverable errors after this duration is elapsed (default 5m0s)help
-schema stringDestination table's schema (default "public")help
-skip-batch-errorsif true, the copy will continue even if a batch failshelp
-skip-headerSkip the first line of the inputhelp
-skip-lines intSkip the first n lines of the input.help
-split stringCharacter to split by (default ",")help
-table stringDestination table for insertions (default "test_table")help
-truncateTruncate the destination table before inserthelp
-verbosePrint more information about copying statisticshelp
-versionShow the version of this toolhelp
-workers intNumber of parallel requests to make (default 1)help

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.