is there a query that can be run against 2.8.x and 3.x dbs that will return
something like
tablename | fieldname | fieldname | fieldname
for example given
create table foo (
a,
b
);
create table bar (
x,
y,
z
);
this should return
foo|a|b|NULL
bar|x|y|z
another alternative would be to have two queries, one returning
foo
bar
and another returning
a|b
and
x|y|z
for foo and bar respectively (iterate querying for each table returned from
first query)
i need to do this via the api NOT the sqlite commandline interface.
kind regards.
-a
--
===============================================================================
| email :: ara [dot] t [dot] howard [at] noaa [dot] gov
| phone :: 303.497.6469
| although gold dust is precious, when it gets in your eyes, it obstructs
| your vision. --hsi-tang
===============================================================================
