On 5/31/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
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
I forgot to say that I would like a solution working from sqlite3, the
console, not from the
programming interface. For instance, I may want to pipe the SQL code to
sqlite3 from a CGI script, or just make some interactive exploration.
Michele Simionato
