On 03-01-18 11:15, 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. > > RBS > What are column delimiters?
|sqlite> select * from test; a, b, c 1, 2, drie 4, 5, zes sqlite> select a,b,c from test; a, b, c 1, 2, drie 4, 5, zes sqlite> select [a],[b],[c] from test; a, b, c 1, 2, drie 4, 5, zes sqlite> select "a","b","c" from test; a, b, c 1, 2, drie 4, 5, zes Of course, you shoul not use single quotes ;) sqlite> select 'a','b','c' from test; 'a', 'b', 'c' a, b, c a, b, c sqlite>| _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
