COPY FROM

The COPY FROM statement bulk imports data from CSV or JSON files efficiently, bypassing standard row-by-row SQL parsing.

Basic Syntax

COPY table_name [(column1, column2, ...)] 
FROM 'file_path' 
[ WITH ( option [, ...] ) ]

-- Available options:
-- FORMAT format_name  (csv or json)
-- HEADER boolean      (for CSV only)
-- DELIMITER 'char'    (for CSV only, default ',')
-- NULL 'string'       (string representing null)

Examples

-- Load data from a CSV file
COPY employees FROM 'employees.csv' WITH (FORMAT CSV, HEADER true);

-- Load data from a JSON array or JSON Lines (JSONL) file
COPY events FROM 'events.json' WITH (FORMAT JSON);

-- Load data mapping only specific columns
COPY users (id, email) FROM 'users.csv' WITH (FORMAT CSV, NULL 'N/A', DELIMITER '|');