> What are column delimiters? create table [table1)([ID] integer, [text_field] text)
I am talking about the square brackets here surrounding the field names. Sorry, used the wrong word in saying delimiters. RBS On Wed, Jan 3, 2018 at 10:44 AM, Luuk <luu...@gmail.com> wrote: > > > 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 > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
