compound_three_primary_keys

Data source: github.com/simon/datasette-psutil · About: /-/psutil demo

26 rows where pk1 = "b" and pk2 = "g"

View and edit SQL

pk2

pk1

Link pk1 pk2 pk3 content
b g a b-g-a
b g b b-g-b
b g c b-g-c
b g d b-g-d
b g e b-g-e
b g f b-g-f
b g g b-g-g
b g h b-g-h
b g i b-g-i
b g j b-g-j
b g k b-g-k
b g l b-g-l
b g m b-g-m
b g n b-g-n
b g o b-g-o
b g p b-g-p
b g q b-g-q
b g r b-g-r
b g s b-g-s
b g t b-g-t
b g u b-g-u
b g v b-g-v
b g w b-g-w
b g x b-g-x
b g y b-g-y
b g z b-g-z

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE compound_three_primary_keys (
  pk1 varchar(30),
  pk2 varchar(30),
  pk3 varchar(30),
  content text,
  PRIMARY KEY (pk1, pk2, pk3)
);
CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content);
Powered by Datasette · Query took 10.781ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo