Hi,

Is there any way in the command line to get the columns in a query  
result?

For example, given an ad-hoc SQL command, such as:

begin;
insert into MyTableOrView select * from SomeSource;
select * from MyTableOrView join SomeOtherTableOrView where condition;
end;

how can I get the column headers in the result?

I know I can get the column info of a table using pragma table_info,  
but I don't think that works for an ad-hoc query.

Thanks,
Tom
BareFeet

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to