compound_three_primary_keys

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

26 rows where pk2 = "v"

View and edit SQL

pk2

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