compound_three_primary_keys

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

38 rows where pk3 = "x"

descending

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

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