Curl.Imp.Insert.Partial - Questdb

This example imports a CSV file with automatic schema detection.

shell

curl -F [email protected] http://localhost:9000/imp?name=table_name

This example overwrites an existing table and specifies a timestamp format and a designated timestamp column. For more information on the optional parameters to specify timestamp formats, partitioning and renaming tables, see the REST API documentation.

bash

curl \
-F schema='[{"name":"ts", "type": "TIMESTAMP", "pattern": "yyyy-MM-dd - HH:mm:ss"}]' \
-F [email protected] 'http://localhost:9000/imp?overwrite=true&timestamp=ts'