compound_three_primary_keys

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

13 rows where pk1 = "b" and pk3 = "i"

descending

Link	pk1	pk2	pk3	content
b,a,i	b	a	i	b-a-i
b,b,i	b	b	i	b-b-i
b,c,i	b	c	i	b-c-i
b,d,i	b	d	i	b-d-i
b,e,i	b	e	i	b-e-i
b,f,i	b	f	i	b-f-i
b,g,i	b	g	i	b-g-i
b,h,i	b	h	i	b-h-i
b,i,i	b	i	i	b-i-i
b,j,i	b	j	i	b-j-i
b,k,i	b	k	i	b-k-i
b,l,i	b	l	i	b-l-i
b,m,i	b	m	i	b-m-i

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