compound_three_primary_keys

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

38 rows where pk3 = "v"

descending

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

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