Accessing SMAT database using sqlite command

To access a SMAT database using sqlite:

  1. sqlite3 <smatdbName>
  2. PRAGMA KEY = <siteName>
    Ignore this step if the SMAT database is not encrypted.
  3. <sql to query>
    For example, select * from smat_msgs.
  4. .quit