/usr/bin/duckdb

Usage: /usr/bin/duckdb [OPTIONS] FILENAME [SQL]

FILENAME is the name of a DuckDB database. A new database is created
if the file does not previously exist.

OPTIONS:
  -ascii                  set output mode to 'ascii'
  -bail                   stop after hitting an error
  -batch                  force batch I/O'
  -box                    set output mode to 'box'
  -column                 set output mode to 'column'
  -cmd COMMAND            run "COMMAND" before reading stdin
  -csv                    set output mode to 'csv'
  -c COMMAND              run "COMMAND" and exit
  -echo                   print commands before execution
  -f FILENAME             read/process named file and exit
  -init FILENAME          read/process named file
  -header                 turn headers on
  -h                      show help message
  -help                   show help message
  -html                   set output mode to HTML
  -interactive            force interactive I/O
  -json                   set output mode to 'json'
  -jsonlines              set output mode to 'jsonlines'
  -line                   set output mode to 'line'
  -list                   set output mode to 'list'
  -markdown               set output mode to 'markdown'
  -newline SEP            set output row separator. Default: '\n'
  -no-init                skip processing the init file
  -no-stdin               exit after processing options instead of reading stdin
  -noheader               turn headers off
  -nullvalue TEXT         set text string for NULL values. Default 'NULL'
  -quote                  set output mode to 'quote'
  -readonly               open the database read-only
  -s COMMAND              run "COMMAND" and exit
  -safe                   enable safe-mode
  -separator SEP          set output column separator. Default: '|'
  -storage-version VER    database storage compatibility version to use. Default: 'v0.10.0'
  -table                  set output mode to 'table'
  -ui                     launches a web interface using the ui extension (configurable with .ui_command)
  -unredacted             allow printing unredacted secrets
  -unsigned               allow loading of unsigned extensions
  -version                show DuckDB version