[sqlite] Re: getting the field names

[Igor Tandetnik]

Michele Simionato
<[EMAIL PROTECTED]> wrote:
Just a quick question, how do I get the fields of a table, i.e. the
equivalent of
PostgreSQL  "select column_name from information_schema.columns where
table_name = '%s' "?

Use sqlite3_column_table_name[16]. Prepare a query of the form "select * 
from tableName" - I believe you don't need to execute it, just prepare, 
for sqlite3_column_table_name to work.

Igor Tandetnik