compound_three_primary_keys

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

38 rows where pk3 = "w"

View and edit SQL

Suggested facets: pk1, pk2

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

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