compound_three_primary_keys

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

26 rows where pk2 = "z"

View and edit SQL

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