compound_three_primary_keys

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

26 rows where pk2 = "y"

View and edit SQL

pk2

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