compound_three_primary_keys

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

26 rows where pk1 = "a" and pk2 = "h"

View and edit SQL

pk2

pk1

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