compound_three_primary_keys

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

12 rows where pk1 = "b" and pk3 = "n"

descending

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

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