Sam Roberts wrote: > On Tue, Nov 9, 2010 at 9:08 PM, Chris Wolf <cw10...@gmail.com> wrote: > >> ...can pragma result sets be accessed in other sql statements? >> >> I wish to use SQLite to perform some data re-formatting, as such, I need >> to output the results >> in CSV format. Unfortunately, the ".output" command does not emit the >> column names >> in the first row. >> > > Does the .headers command help? > >
Silly me - yes it does. I missed that some how. Thanks! I still believe that there are use-cases where one may want to access columns names in a sql statement. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
