compound_three_primary_keys

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

39 rows where pk3 = "i"

View and edit SQL

Suggested facets: pk1, pk2

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

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