compound_three_primary_keys

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

38 rows where pk3 = "s"

descending

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

Advanced export

JSON shape: default, array, newline-delimited, object

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);