OK, thanks. I am getting the information now from the create table statements and sofar that seems to work OK. Just wanted to make sure there wasn't a better way to handle this.
RBS On Wed, Jan 3, 2018 at 11:08 AM, Richard Hipp <[email protected]> wrote: > On 1/3/18, Bart Smissaert <[email protected]> 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. > > No. SQLite does not retain that information in its internal symbol > tables. You'll have to parse out the original CREATE TABLE statements > to figure that out. > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
