Reference

spatialite(1)

CLI backend for SpatiaLite

NAME

spatialite - CLI backend for SpatiaLite

SYNOPSIS

FCspatialiteF[0] [OPTIONS] FILENAME [SQL]

DESCRIPTION

spatialite is a CLI backend for SpatiaLite.

OPTIONS

FC-bailF[0]

stop after hitting an error

FC-batchF[0]

force batch I/O

FC-columnF[0]

set output mode to 'column'

FC-cmdF[0] command

run command before reading stdin

FC-csvF[0]

set output mode to 'csv'

FC-echoF[0]

print commands before execution

FC-initF[0] filename

read/process named file

FC-[no]headerF[0]

turn headers on or off

FC-helpF[0]

show help message

FC-htmlF[0]

set output mode to HTML

FC-interactiveF[0]

force interactive I/O

FC-lineF[0]

set output mode to 'line'

FC-listF[0]

set output mode to 'list'

FC-multiplexF[0]

enable the multiplexor VFS (if support built in)

FC-nullvalueF[0] 'text'

set text string for NULL values

FC-separatorF[0] 'x'

set output field separator (|)

FC-statsF[0]

print memory stats before each finalize

FC-versionF[0]

show SQLite version

FC-vfsF[0] NAME

use NAME as the default VFS

FC-vfstraceF[0]

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

History