{"id":930,"date":"2020-03-18T23:08:30","date_gmt":"2020-03-18T22:08:30","guid":{"rendered":"https:\/\/andreas-klingler.de\/infosec\/?p=930"},"modified":"2023-12-20T20:43:22","modified_gmt":"2023-12-20T19:43:22","slug":"sqlite","status":"publish","type":"post","link":"https:\/\/infosec.andreas-klingler.de\/?p=930","title":{"rendered":"Sqlite"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Show tables<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">.tables<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Show columns \/ schema from a&nbsp;table<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">PRAGMA table_info(users)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Show tables .tables Show columns \/ schema from a&nbsp;table <span class=\"caps\">PRAGMA<\/span> table_info(users)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wp_typography_post_enhancements_disabled":false,"footnotes":""},"categories":[468],"tags":[221,222],"class_list":["post-930","post","type-post","status-publish","format-standard","hentry","category-general","tag-sqlite","tag-sqlite3"],"_links":{"self":[{"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=\/wp\/v2\/posts\/930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=930"}],"version-history":[{"count":3,"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions"}],"predecessor-version":[{"id":3824,"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions\/3824"}],"wp:attachment":[{"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infosec.andreas-klingler.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}