compound_three_primary_keys

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

52 rows where pk2 = "e"

View and edit SQL

Suggested facets: pk1, pk3

Link pk1 pk2 pk3 content
a e a a-e-a
a e b a-e-b
a e c a-e-c
a e d a-e-d
a e e a-e-e
a e f a-e-f
a e g a-e-g
a e h a-e-h
a e i a-e-i
a e j a-e-j
a e k a-e-k
a e l a-e-l
a e m a-e-m
a e n a-e-n
a e o a-e-o
a e p a-e-p
a e q a-e-q
a e r a-e-r
a e s a-e-s
a e t a-e-t
a e u a-e-u
a e v a-e-v
a e w a-e-w
a e x a-e-x
a e y a-e-y
a e z a-e-z
b e a b-e-a
b e b b-e-b
b e c b-e-c
b e d b-e-d
b e e b-e-e
b e f b-e-f
b e g b-e-g
b e h b-e-h
b e i b-e-i
b e j b-e-j
b e k b-e-k
b e l b-e-l
b e m b-e-m
b e n b-e-n
b e o b-e-o
b e p b-e-p
b e q b-e-q
b e r b-e-r
b e s b-e-s
b e t b-e-t
b e u b-e-u
b e v b-e-v
b e w b-e-w
b e x b-e-x
b e y b-e-y
b e z b-e-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.572ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo