Provided by: csvkit_1.4.0-1_all bug

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)