On Fri, Apr 23, 2010 at 8:39 AM, Adam DeVita <adev...@verifeye.com> wrote: > Could you include a bit more information about your post? (Version number, > operating system etc.) > > I'm unsure if you have compiled something or are using the command line > tool. > > There are lots of very knowledgeable and helpful people on the list. > > On Thu, Apr 22, 2010 at 6:31 PM, Derek Martin <demar...@akamai.com> wrote: > >> Hi, >> >> I have a query that produces about 10 columns, some of which are very >> wide. When I run sqlite3 with -column -header, it truncates all >> fields to 10 characters. This makes the query absolutely useless. >> How can I turn off this truncation? >> >> I already tried explicitly setting the width to 0, that did not help. >>
You have to set the width of every column with .width. I don't know the exact syntax of .width and how to effectively turn .width constraint off. You might try .mode line, which will print one value per line. Better yet, ditch the command line tool for these kind of things and use something like Perl, Python or Tcl to work with your db. If you are good with bash, you can also do a lot of magic by querying a sqlite db via shell scripts. >> Thanks. >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > VerifEye Technologies Inc. > 905-948-0015x245 > 7100 Warden Ave, Unit 3 > Markham ON, L3R 8B5 > Canada > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
