Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

CSV

Read a CSV file and auto-infer options:

SELECT *
FROM 'penguins.csv';

Read a CSV file from a URL and auto-infer options:

SELECT *
FROM 'http://blobs.duckdb.org/data/penguins.csv';

Read a CSV file with custom options:

SELECT *
FROM read_csv('http://blobs.duckdb.org/data/penguins.csv', nullstr = 'NA');