compound_three_primary_keys

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

39 rows where pk2 = "m"

View and edit SQL

Suggested facets: pk1, pk3

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

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.268ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo