compound_three_primary_keys

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

39 rows where pk3 = "a"

View and edit SQL

Suggested facets: pk1, pk2

Link pk1 pk2 pk3 content
a a a a-a-a
a b a a-b-a
a c a a-c-a
a d a a-d-a
a e a a-e-a
a f a a-f-a
a g a a-g-a
a h a a-h-a
a i a a-i-a
a j a a-j-a
a k a a-k-a
a l a a-l-a
a m a a-m-a
a n a a-n-a
a o a a-o-a
a p a a-p-a
a q a a-q-a
a r a a-r-a
a s a a-s-a
a t a a-t-a
a u a a-u-a
a v a a-v-a
a w a a-w-a
a x a a-x-a
a y a a-y-a
a z a a-z-a
b a a b-a-a
b b a b-b-a
b c a b-c-a
b d a b-d-a
b e a b-e-a
b f a b-f-a
b g a b-g-a
b h a b-h-a
b i a b-i-a
b j a b-j-a
b k a b-k-a
b l a b-l-a
b m a b-m-a

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 10.441ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo