compound_three_primary_keys

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

26 rows where pk2 = "x"

View and edit SQL

pk2

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