On 2 September 2010 11:24, Arthur Rance <arthur_ra...@hotmail.com> wrote: > > Hello. > > Is there a pager for sqlite3 default client ? > > sqlite> select count(*) from mytable; > > 37899 > sqlite> select * from mytable; > ... > (too much entries, can't read anything) > ...
Not built in to the shell. But you can do: sqlite3 tst.db "select * from myTable;" | more Or look into "SELECT ... LIMIT x OFFSET y" > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
