.\" DO NOT MODIFY THIS FILE! It was generated by help2man 1.49.3. .TH SQL2CSV "1" "March 2023" "sql2csv 1.1.1" "User Commands" .SH NAME sql2csv \- manual page for sql2csv 1.1.1 .SH DESCRIPTION usage: sql2csv [\-h] [\-v] [\-l] [\-V] [\-\-db CONNECTION_STRING] [\-\-query QUERY] .IP [\-e ENCODING] [\-H] [FILE] .PP Execute an SQL query on a database and output the result to a CSV file. .SS "positional arguments:" .TP FILE The file to use as SQL query. If FILE and \fB\-\-query\fR are omitted, the query is piped data via STDIN. .SS "options:" .TP \fB\-h\fR, \fB\-\-help\fR show this help message and exit .TP \fB\-v\fR, \fB\-\-verbose\fR Print detailed tracebacks when errors occur. .TP \fB\-l\fR, \fB\-\-linenumbers\fR Insert a column of line numbers at the front of the output. Useful when piping to grep or as a simple primary key. .TP \fB\-V\fR, \fB\-\-version\fR Display version information and exit. .TP \fB\-\-db\fR CONNECTION_STRING An sqlalchemy connection string to connect to a database. .TP \fB\-\-query\fR QUERY The SQL query to execute. Overrides FILE and STDIN. .TP \fB\-e\fR ENCODING, \fB\-\-encoding\fR ENCODING Specify the encoding of the input query file. .TP \fB\-H\fR, \fB\-\-no\-header\-row\fR Do not output column names. .SH "SEE ALSO" The full documentation for .B sql2csv is maintained as a Texinfo manual. If the .B info and .B sql2csv programs are properly installed at your site, the command .IP .B info sql2csv .PP should give you access to the complete manual.