I have values being cut off and would like to display the full values.
Sqlite3 -column -header locations.dbs "
select n.namelist, f.state, t.state
from names n
left join locations l on l.id = n.id
left join statenames f on f.st = l.st
left join statenames t on t.st = l.stto
where n.timing > 200601 and count(n.timing)<=15"
Which gives me
name From State To State
---------- ----------- ----------
Jack Connecticut Louisiana
Jeff Danie New Hampshi New Hampsh
The names are being truncated down to 10 characters or the length of the first row of data, whichever is longer. How can I stop this from happening without making the columns larger than they have to be?
Thanks
There doesn't appear to be a way to make it automatic, but you can use the .width
command to manually specify the column widths.
See here (search the section for .width
).
you could just use column (the unix command) like this:
sqlite3 -list -separator "|" -header db.dbs "Select ...." | column -t -s "|"
-list
and -separator
can be omitted, as they are defaults
Expanding on the answer by zuloo, it is possible to use the interactive prompt and have automatic column widths too.
Apart from column
you will also need rlwrap (sudo apt-get install rlwrap
if you're on Ubuntu). You run it like this:
rlwrap -a -N -c -z pipeto sqlite3 -header locations.dbs
Or you can put an alias in your .bashrc
or similar:
alias sqlite="rlwrap -a -N -c -z pipeto sqlite3 -header"
In the sqlite console, you can run your query like this:
select * from names; | column -n -t -s '|'
Or, to make it nicer, put a script somewhere in your $PATH
:
#!/bin/bash
column -n -t -s '|'
Let's say it's called pp
, don't forget to make it executable with chmod u+x pp
. Then you can use the interactive prompt like this:
select * from names; | pp
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With