compound_three_primary_keys

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

52 rows where pk2 = "f"

View and edit SQL

Suggested facets: pk1, pk3

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