compound_three_primary_keys

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

26 rows where pk1 = "a" and pk3 = "i"

✎ View and edit SQL

This data as json, CSV (advanced)

pk3 ✖

pk1 ✖

Link pk1 pk2 pk3 content
a,a,i a a i a-a-i
a,b,i a b i a-b-i
a,c,i a c i a-c-i
a,d,i a d i a-d-i
a,e,i a e i a-e-i
a,f,i a f i a-f-i
a,g,i a g i a-g-i
a,h,i a h i a-h-i
a,i,i a i i a-i-i
a,j,i a j i a-j-i
a,k,i a k i a-k-i
a,l,i a l i a-l-i
a,m,i a m i a-m-i
a,n,i a n i a-n-i
a,o,i a o i a-o-i
a,p,i a p i a-p-i
a,q,i a q i a-q-i
a,r,i a r i a-r-i
a,s,i a s i a-s-i
a,t,i a t i a-t-i
a,u,i a u i a-u-i
a,v,i a v i a-v-i
a,w,i a w i a-w-i
a,x,i a x i a-x-i
a,y,i a y i a-y-i
a,z,i a z i a-z-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 11.482ms · Data source: github.com/simon/datasette-psutil · About: /-/psutil demo