delimiters delimit, so they are not part of the context.. such information aobut delimiters is never saved... since they havce done their job delimiiting already.
Why do you want this? On Wed, Jan 3, 2018 at 2:50 AM, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
