compound_three_primary_keys

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

38 rows where pk3 = "q"

View and edit SQL

Suggested facets: pk1, pk2

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

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