compound_three_primary_keys

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

38 rows where pk3 = "p"

descending

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

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