SYNOPSIS

spatialite [OPTIONS] FILENAME [SQL]

DESCRIPTION

spatialite is a CLI backend for SpatiaLite.

OPTIONS

-bail

stop after hitting an error

-batch

force batch I/O

-column

set output mode to 'column'

-cmd command

run command before reading stdin

-csv

set output mode to 'csv'

-echo

print commands before execution

-init filename

read/process named file

-[no]header

turn headers on or off

-help

show help message

-html

set output mode to HTML

-interactive

force interactive I/O

-line

set output mode to 'line'

-list

set output mode to 'list'

-multiplex

enable the multiplexor VFS (if support built in)

-nullvalue 'text'

set text string for NULL values

-separator 'x'

set output field separator (|)

-stats

print memory stats before each finalize

-version

show SQLite version

-vfs NAME

use NAME as the default VFS

-vfstrace

enable tracing of all VFS calls (if support built in)