compound_three_primary_keys

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

26 rows where pk2 = "s"

View and edit SQL

pk2

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