Provided by: csvkit_1.0.2-2_all
NAME
sql2csv - manual page for sql2csv 1.0.2
DESCRIPTION
usage: sql2csv [-h] [-v] [-l] [-V] [--db CONNECTION_STRING] [--query QUERY] [-e ENCODING] [-H] [FILE] Execute an SQL query on a database and output the result to a CSV file. positional arguments: FILE The file to use as SQL query. If both FILE and QUERY are omitted, query will be read from STDIN. optional arguments: -h, --help show this help message and exit -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. -V, --version Display version information and exit. --db CONNECTION_STRING An sqlalchemy connection string to connect to a database. --query QUERY The SQL query to execute. If specified, it overrides FILE and STDIN. -e ENCODING, --encoding ENCODING Specify the encoding of the input query file. -H, --no-header-row Do not output column names.
SEE ALSO
The full documentation for sql2csv is maintained as a Texinfo manual. If the info and sql2csv programs are properly installed at your site, the command info sql2csv should give you access to the complete manual.