Column headers are different if obtained from a table or a view:
% sqlite3 a
SQLite version 3.7.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE a (a);
sqlite> CREATE VIEW b AS SELECT * FROM a;
sqlite> INSERT INTO a VALUES ('foo');
sqlite> .header on
sqlite> SELECT v.a FROM a v;
a
foo
sqlite> SELECT v.a FROM b v;
v.a
foo
--
Lapo Luchini - http://lapo.it/
“Never worry about theory as long as the machinery does what it's
supposed to do.” (Robert A. Heinlein, "Waldo & Magic, Inc.", 1950)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
