> Is there any way to do something along the lines of PRAGMA
> some_command(SELECT * FROM table1 JOIN table2) and have it return A, B, C,
> a, b, c as the headers?
If you really want to do it with "table_info", you could create a
temporary view with the "select":
-
> Is there any way to do something along the lines of PRAGMA
> some_command(SELECT * FROM table1 JOIN table2) and have it return A, B, C,
> a, b, c as the headers?
If you insist on getting results as resultset then there's no way to
do that. But you can do the similar thing by using API like
sqlit
Hi,
I find the PRAGMA table_info(*tablename)* command very helpful.
However, sometimes I want to extract table headers for a table constructed
by a query which does not have the exact same headers as any one table in my
database.
For example:
Table 1 headers: A, B, and C
Table 2 headers: a, b,
3 matches
Mail list logo