compound_three_primary_keys

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

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

View and edit SQL

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