.dump ?tabl? ... Dump the database in an SQL text format
.dump access
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE access ( service TEXT NOT NULL, client TEXT NOT NULL, client_type INTEGER NOT NULL, auth_value INTEGER NOT NULL, auth_reason INTEGER NOT NULL, auth_version INTEGER NOT NULL, csreq BLOB, policy_id INTEGER, indirect_object_identifier_type INTEGER, indirect_object_identifier TEXT NOT NULL DEFAULT 'UNUSED', indirect_object_code_identity BLOB, flags INTEGER, last_modified INTEGER NOT NULL DEFAULT (CAST(strftime('%s','now') AS INTEGER)), pid INTEGER, pid_version INTEGER, boot_uuid TEXT NOT NULL DEFAULT 'UNUSED', last_reminded INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (service, client, client_type, indirect_object_identifier), FOREIGN KEY (policy_id) REFERENCES policies(id) ON DELETE CASCADE ON UPDATE CASCADE);
INSERT INTO access VALUES('kTCCServiceSystemPolicyAllFiles','com.gog.galaxy',0,2,4,1,X'fade0c000000009c0000000100000006000000020000000e636f6d2e676f672e67616c6178790000000000060000000f000000060000000e000000010000000a2a864886f76364060206000000000000000000060000000e000000000000000a2a864886f7636406010d0000000000000000000b000000000000000a7375626a6563742e4f550000000000010000000a395753333651383838360000',NULL,0,'UNUSED',NULL,0,1641059835,NULL,NULL,'UNUSED',0);
.read filename Execute filename
.output filename |stdout | Direct output
| .explain ON|OFF Control output mode suitable for EXPLAIN. default on
| .import file table | Import data from FILE into TABLE
| .log file|
off |
stdout |
stderr Control logging
.mode mode ?tabl?
display current output mode: column --wrap 60 --wordwrap off --noquote
OR
Set output mode (format) where mode is one of:
column Left-aligned columns.
Long column names with short values will place many spaces between values.
select service,client,client_type,auth_value,auth_reason,auth_version,csreq,policy_id from access limit 2;
service client client_type auth_value auth_reason auth_version csreq policy_id
------------------------------- -------------- ----------- ---------- ----------- ------------ ----- ---------
kTCCServiceSystemPolicyAllFiles com.gog.galaxy 0 2 4 1 ??
kTCCServiceAccessibility com.gog.galaxy 0 2 4 1 ??
.width num1 num2 …
label weight source identifier version conditions
------------- ---------- ---------- ----------------- ---------- -----------------
google chrome 200.0 EQHXZ com.google.Chrome {errors=[-613]}
google chrome 300.0 EQHXZ com.google.Chrome {errors=[-613]}
| csv Comma-separated values label,weight,source,identifier,version,conditions
"google chrome",200.0,EQHXZ,com.google.Chrome,,{errors=[-613]}
"google chrome (canary)",300.0,EQHXZ,com.google.Chrome.canary,,{errors=[-613]}
| html HTML <table> code
<TR><TH>label</TH> <TH>weight</TH> <TH>source</TH>
<TH>identifier</TH> <TH>version</TH> <TH>conditions</TH> </TR>
<TR><TD>google chrome</TD> <TD>200.0</TD> <TD>EQHXZ</TD>
<TD>com.google.Chrome</TD> <TD></TD> <TD>{errors=[-613]}</TD> </TR>
<TR><TD>google chrome (canary)</TD> <TD>300.0</TD> <TD>EQHXZ</TD>
<TD>com.google.Chrome.canary</TD> <TD></TD> <TD>{errors=[-613]}</TD> </TR>
Which a browser will display as:
| label | weight | source |
identifier | version | conditions |
|---|
| google chrome | 200.0 | EQHXZ |
com.google.Chrome | | {errors=[-613]} |
| google chrome (canary) | 300.0 | EQHXZ |
com.google.Chrome.canary | | {errors=[-613]} |
| insert SQL insert statements for TABLE
INSERT INTO table(label,weight,source,identifier,version,conditions)
VALUES('google chrome',200.0,'EQHXZ','com.google.Chrome',NULL,'{errors=[-613]}');
INSERT INTO table(label,weight,source,identifier,version,conditions)
VALUES('google chrome (canary)',300.0,'EQHXZ','com.google.Chrome.canary',NULL,'{errors=[-613]}');
| line One value per line
label = google chrome
weight = 200.0
source = EQHXZ
identifier = com.google.Chrome
version =
conditions = {errors=[-613]}
label = google chrome (canary)
weight = 300.0
source = EQHXZ
identifier = com.google.Chrome.canary
version =
conditions = {errors=[-613]}
| list Values delimited by .separator string
label|weight|source|identifier|version|conditions
google chrome|200.0|EQHXZ|com.google.Chrome||{errors=[-613]}
google chrome (canary)|300.0|EQHXZ|com.google.Chrome.canary||{errors=[-613]}
label,weight,source,identifier,version,conditions
google chrome,200.0,EQHXZ,com.google.Chrome,,{errors=[-613]}
google chrome (canary),300.0,EQHXZ,com.google.Chrome.canary,,{errors=[-613]}
| tabs Tab-separated values
label weight source identifier version conditions
google chrome 200.0 EQHXZ com.google.Chrome {errors=[-613]}
google chrome (canary) 300.0 EQHXZ com.google.Chrome.canary {errors=[-613]}
Tcl | Tcl list elements "label" "weight" "source" "identifier" "version" "conditions"
"google chrome" "200.0" "EQHXZ" "com.google.Chrome" "" "{errors=[-613]}"
"google chrome (canary)" "300.0" "EQHXZ" "com.google.Chrome.canary" "" "{errors=[-613]}"
| | | | | | | | |
|
.header(s) ON|OFF | Turn headers on or off
| .bail ON|OFF | Stop on error. Default OFF
| .prompt main continue| prompts
| .backup ?DB? fILE | DEFAULT "MAIN"
| .restore ?DB? file | DEFAULT "MAIN"
| .show current values
echo: off
eqp: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
colseparator: "|"
rowseparator: "\n"
stats: off
width:
| .stats ON|OFF | Set stats
| .timeout ms | Wait for locked table.
| .vfsname ?AUX? | VFS stack name unix
| .timer ON|OFF Control display of the CPU time
Run Time: real 0.001 user 0.000098 sys 0.000046
| .databases† List names and files of attached databases
.nullvalue string display string for NULLs
.separator string used by output mode and .import
| .trace file|off | Display statements as they are run.
| .echo ON|OFF |
| .quit|
| .help
| | | | | | | | | | | | | | | | | | | | | | | | | | | |