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)
| Option | Description | Source |
|---|---|---|
-auto-column-mapping | Automatically map CSV headers to database columns with the same names | help |
-batch-byte-size int | Max number of bytes to send in a batch (default 4194304) | help |
-batch-size int | Number of rows per insert. | help |
-buffer-byte-size int | Number of bytes to buffer, it has to be big enough to hold a full row (default 2097152) | help |
-column-mapping string | Column mapping from CSV to database columns (format: "csv_col1:db_col1,csv_col2:db_col2" or JSON) | help |
-columns string | Comma-separated columns present in CSV | help |
-connection string | PostgreSQL connection url (default "host=localhost user=postgres sslmode=disable") | help |
-copy-options string | Additional options to pass to COPY (e.g., NULL 'NULL') (default "CSV") | help |
-db-name string | (deprecated) Database where the destination table exists | help |
-disable-direct-compress | Disable using direct compress to write data to TimescaleDB | help |
-disable-windows-1252-handling | Disable automatic encoding handling | help |
-enable-client-side-sorting | Guaranteed data order in place on the client side | help |
-escape character | The ESCAPE character to use during COPY (default '"') | help |
-file string | File to read from rather than stdin | help |
-header-line-count int | (deprecated) Number of header lines (default 1) | help |
-import-id string | ImportID to guarantee idempotency | help |
-limit int | Number of rows to insert overall; | help |
-log-batches | Whether to time individual batches. | help |
-no-retry | Disable retrying on recoverable errors | help |
-on-conflict-do-nothing | Skip duplicate rows on unique constraint violations | help |
-quote character | The QUOTE character to use during COPY (default '"') | help |
-reporting-period duration | Period to report insert stats; | help |
-retry-timeout duration | Abort retrying recoverable errors after this duration is elapsed (default 5m0s) | help |
-schema string | Destination table's schema (default "public") | help |
-skip-batch-errors | if true, the copy will continue even if a batch fails | help |
-skip-header | Skip the first line of the input | help |
-skip-lines int | Skip the first n lines of the input. | help |
-split string | Character to split by (default ",") | help |
-table string | Destination table for insertions (default "test_table") | help |
-truncate | Truncate the destination table before insert | help |
-verbose | Print more information about copying statistics | help |
-version | Show the version of this tool | help |
-workers int | Number of parallel requests to make (default 1) | help |