spatialite

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)