[sqlite] pragma table_info(tbl)

2018-03-02 Thread mike otwell
I have a table named person that contains 13 columns. pragma table_info(person) returns 13 rows of cid. I assume this is the primary key... do I need to add something to get the column name along with cid? -- No trees were killed in the sending of this message. However, a large number of electron

[sqlite] what internal table contains column names in a table?

2018-03-01 Thread mike otwell
I want to write a program that generates insert & update statements for a table. what internal table would I query to get the column names in a table? -- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cg