Provided by: csvkit_1.4.0-1_all 
NAME
csvsql - manual page for csvsql 1.4.0
DESCRIPTION
usage: csvsql [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]
[-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-L LOCALE] [-S] [--blanks] [--null-value
NULL_VALUES [NULL_VALUES ...]] [--date-format DATE_FORMAT] [--datetime-format DATETIME_FORMAT]
[-H] [-K SKIP_LINES] [-v] [-l] [--zero] [-V] [-i
{firebird,mssql,mysql,oracle,postgresql,sqlite,sybase}] [--db CONNECTION_STRING] [--query QUERIES]
[--insert] [--prefix PREFIX] [--before-insert BEFORE_INSERT] [--after-insert AFTER_INSERT]
[--tables TABLE_NAMES] [--no-constraints] [--unique-constraint UNIQUE_CONSTRAINT] [--no-create]
[--create-if-not-exists] [--overwrite] [--db-schema DB_SCHEMA] [-y SNIFF_LIMIT] [-I] [--chunk-size
CHUNK_SIZE] [FILE ...]
Generate SQL statements for one or more CSV files, or execute those statements directly on a database,
and execute one or more SQL queries.
positional arguments:
FILE The CSV file(s) to operate on. If omitted, will accept input as piped data via STDIN.
options:
-h, --help
show this help message and exit
-d DELIMITER, --delimiter DELIMITER
Delimiting character of the input CSV file.
-t, --tabs
Specify that the input CSV file is delimited with tabs. Overrides "-d".
-q QUOTECHAR, --quotechar QUOTECHAR
Character used to quote strings in the input CSV file.
-u {0,1,2,3}, --quoting {0,1,2,3}
Quoting style used in the input CSV file. 0 = Quote Minimal, 1 = Quote All, 2 = Quote Non-numeric,
3 = Quote None.
-b, --no-doublequote
Whether or not double quotes are doubled in the input CSV file.
-p ESCAPECHAR, --escapechar ESCAPECHAR
Character used to escape the delimiter if --quoting 3 ("Quote None") is specified and to escape
the QUOTECHAR if --no-doublequote is specified.
-z FIELD_SIZE_LIMIT, --maxfieldsize FIELD_SIZE_LIMIT
Maximum length of a single field in the input CSV file.
-e ENCODING, --encoding ENCODING
Specify the encoding of the input CSV file.
-L LOCALE, --locale LOCALE
Specify the locale (en_US) of any formatted numbers.
-S, --skipinitialspace
Ignore whitespace immediately following the delimiter.
--blanks
Do not convert "", "na", "n/a", "none", "null", "." to NULL.
--null-value NULL_VALUES [NULL_VALUES ...]
Convert this value to NULL. --null-value can be specified multiple times.
--date-format DATE_FORMAT
Specify a strptime date format string like "%m/%d/%Y".
--datetime-format DATETIME_FORMAT
Specify a strptime datetime format string like "%m/%d/%Y %I:%M %p".
-H, --no-header-row
Specify that the input CSV file has no header row. Will create default headers (a,b,c,...).
-K SKIP_LINES, --skip-lines SKIP_LINES
Specify the number of initial lines to skip before the header row (e.g. comments, copyright
notices, empty rows).
-v, --verbose
Print detailed tracebacks when errors occur.
-l, --linenumbers
Insert a column of line numbers at the front of the output. Useful when piping to grep or as a
simple primary key.
--zero When interpreting or displaying column numbers, use zero-based numbering instead of the default
1-based numbering.
-V, --version
Display version information and exit.
-i {firebird,mssql,mysql,oracle,postgresql,sqlite,sybase}, --dialect
{firebird,mssql,mysql,oracle,postgresql,sqlite,sybase}
Dialect of SQL to generate. Cannot be used with --db.
--db CONNECTION_STRING
If present, a SQLAlchemy connection string to use to directly execute generated SQL on a database.
--query QUERIES
Execute one or more SQL queries delimited by ";" and output the result of the last query as CSV.
QUERY may be a filename. --query may be specified multiple times.
--insert
Insert the data into the table. Requires --db.
--prefix PREFIX
Add an expression following the INSERT keyword, like OR IGNORE or OR REPLACE.
--before-insert BEFORE_INSERT
Execute SQL before the INSERT command. Requires --insert.
--after-insert AFTER_INSERT
Execute SQL after the INSERT command. Requires --insert.
--tables TABLE_NAMES
A comma-separated list of names of tables to be created. By default, the tables will be named
after the filenames without extensions or "stdin".
--no-constraints
Generate a schema without length limits or null checks. Useful when sampling big tables.
--unique-constraint UNIQUE_CONSTRAINT
A column-separated list of names of columns to include in a UNIQUE constraint.
--no-create
Skip creating the table. Requires --insert.
--create-if-not-exists
Create the table if it does not exist, otherwise keep going. Requires --insert.
--overwrite
Drop the table if it already exists. Requires --insert. Cannot be used with --no-create.
--db-schema DB_SCHEMA
Optional name of database schema to create table(s) in.
-y SNIFF_LIMIT, --snifflimit SNIFF_LIMIT
Limit CSV dialect sniffing to the specified number of bytes. Specify "0" to disable sniffing
entirely, or "-1" to sniff the entire file.
-I, --no-inference
Disable type inference when parsing the input.
--chunk-size CHUNK_SIZE
Chunk size for batch insert into the table. Requires --insert.
SEE ALSO
The full documentation for csvsql is maintained as a Texinfo manual. If the info and csvsql programs are
properly installed at your site, the command
info csvsql
should give you access to the complete manual.
csvsql 1.4.0 February 2024 CSVSQL(1)