Re: [sqlite] accessing table column names other then via pragma, or...

Sam Roberts wrote: > On Tue, Nov 9, 2010 at 9:08 PM, Chris Wolf 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.

Re: [sqlite] accessing table column names other then via pragma, or...

On Tue, Nov 9, 2010 at 9:08 PM, Chris Wolf 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

[sqlite] accessing table column names other then via pragma, or...

...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. I was hoping that something like