compound_three_primary_keys

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

38 rows where pk3 = "u"

View and edit SQL

Suggested facets: pk1, pk2

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

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