On 2018/01/03 12:15 PM, Bart Smissaert wrote:
Is there a way with pragma table_info or otherwise (other than parsing the
table create statement from SQLite_master) to get the column names
including the column delimiters, eg double quotes or square brackets? So I
would get eg: [column1] [column2] etc. if indeed the column names were
delimited like that.

Don't think so, those are meta, it's like asking if there is a way to tell from the compiled program what the comments in the code was that the programmer inserted when coding...  The compiler very correctly discards it and no trace of it exists in the compiled program.

I have made a few parsers for the SQLite schemata and also you can probably copy paste some code for it directly from the SQLite source, but may I ask why you would need that information? (Perhaps the problem can be solved another way)



_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to