summaryrefslogtreecommitdiffstats
path: root/q
diff options
context:
space:
mode:
authorHarel Ben-Attia <harelba@gmail.com>2014-03-03 17:07:16 -0500
committerHarel Ben-Attia <harelba@gmail.com>2014-03-03 17:16:52 -0500
commit2b88e3cb4cb0471d150ca6efdb89d9fe316d0bc6 (patch)
treecdd04232e002778b5efd2293a56e665eda60ff7f /q
parentfdb8f8753b6efe1bf7698bf7824c44592c669a75 (diff)
Fixed help text
Diffstat (limited to 'q')
-rwxr-xr-xq7
1 files changed, 6 insertions, 1 deletions
diff --git a/q b/q
index e2b1c01..642dcba 100755
--- a/q
+++ b/q
@@ -90,7 +90,11 @@ parser = OptionParser(usage="""
Its purpose is to bring SQL expressive power to manipulating text data using the Linux command line.
Basic usage is q "<sql like query>" where table names are just regular file names (Use - to read from standard input)
- Columns are named c1..cN and delimiter can be set using the -d (or -t) option.
+ When the input contains a header row, use -H, and column names will be set according to the header row content. If there isn't a header row, then columns will automatically be named c1..cN.
+
+ Column types are detected automatically. Use -A in order to see the column name/type analysis.
+
+ Delimiter can be set using the -d (or -t) option. Output delimiter can be set using -D
All sqlite3 SQL constructs are supported.
@@ -105,6 +109,7 @@ parser = OptionParser(usage="""
Example 3: sudo find /tmp -ls | q "select c5,c6,sum(c7)/1024.0/1024 as total from - group by c5,c6 order by total desc"
This example will output the total size in MB per user+group in the /tmp subtree
+
See the help or https://github.com/harelba/q for more details.
""")
parser.add_option("-b","--beautify",dest="beautify",default=default_beautify,action="store_true",