Scroll to navigation

spatialite(1) spatialite(1)

NAME

spatialite - CLI backend for SpatiaLite

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)
21 March 2020