compound_three_primary_keys

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

39 rows where pk3 = "e"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pk1, pk2

pk3 ✖

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

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