compound_three_primary_keys

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

26 rows where pk2 = "w"

View and edit SQL

pk2

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