compound_three_primary_keys

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

52 rows where pk2 = "a"

View and edit SQL

Suggested facets: pk1, pk3

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