On Tue, Feb 19, 2013 at 4:04 PM, Patrik Nilsson <nipatriknils...@gmail.com>wrote:
> (some alias command: abc is an alias of abc_v1 for this connection) > > select * from abc > > (The last command would then "select * from abc_v1".) > How about: CREATE TEMPORARY VIEW abc AS SELECT * FROM abc_v1; e.g. sqlite> create temporary view x as select * from sqlite_master; sqlite> select * from x; sqlite> create table t(a,b,c); sqlite> select * from x; table|t|t|2|CREATE TABLE t(a,b,c) -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
