Re: [sqlite] sqlite bug? .mode insert does not quote identifiers

On 4/6/18, jon baldry wrote: > I have identifiers that unfortunately have a hyphen within them. > > I want to output the data from the tables with those identifiers using > .mode insert and .out foo.sql for re-loading. > > I have worked around this in PHP to modify the output,

[sqlite] sqlite bug? .mode insert does not quote identifiers

I have identifiers that unfortunately have a hyphen within them. I want to output the data from the tables with those identifiers using .mode insert and .out foo.sql for re-loading. I can't use .dump easily as i want to modify the tables before re-loading the data, so .mode insert seemed my