Robert Citek <robert.ci...@...> writes: > > Nothing with just SQL alone, although you can get close: > > http://www.sqlite.org/faq.html#q7 > > You could use a command pipeline, but that only works if the table has > at least one record: > > $ sqlite3 -separator ", " -header sample.db 'select * from > sqlite_master limit 1; ' | > head -1 > type, name, tbl_name, rootpage, sql > > Or you can do it from within a scripting language, e.g. ruby: > > $ ruby -e ' > require "sqlite3" ; > db=SQLite3::Database.new("sample.db") ; > row=db.execute2("select * from sqlite_master limit 0 ") ; > puts row.join(", ") ; > ' > type, name, tbl_name, rootpage, sql > > Good luck and let us know what works for you. >
Hello, thank you for your hints. The shell solution helps me a lot - it is simple and efficient. Thank god there is http://gnuwin32.sourceforge.net/ that lets me use native gnu under WinXP. greetings Oliver [...] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
